Hello again Infonauta, welcome or welcome to a new installment of your YouTube channel Infoductiva ...
this time we will continue with the course of databases
and in this particular video we are going to delve
in the input masks
interesting, right?
We begin ...
good first
I'm going to focus on the table students
I'm going to start
ending
all the field of date of birth ...
for this I will fill in a fourth student in this case
Julia ...
López
Alvarez
and then at the time of writing the date of birth notice that here we have the date box ... remember that this is
as a selector to be able to select a date
next to which we are
in the current day
since if this is going to help me to put a date of birth it does not make sense for us to use
this selector since we would have to leave until the year in question, go backwards during
enough pulsations ... in short this is interesting stop when we have to put a date close
to the creation date for example
from the student
so
first issue to consider
with the entrance masks ... the entrance masks
we only have to use them in case we have clear the fixed mold to be used at the time of entering data if it is not so
let's say that field in question in which you are you thinking
he is not a suitable candidate
to be able to add input mask ... second
the entrance masks
do not support, for example, the fact that you have this date selector enabled
so that having these two limitations clear
what I'm going to do is go to the design
from the table in question, to the design
from the students table
and what I'm going to do is in the date field
turn off the display
of this selector
for this I am going to put a date already ... observe that when entering I can write letters
which should not be like that ... I can enter scripts ... okay?
Take this into account for what we are going to do next and I am going to put you on the date of birth because on the 20th, for example
of the deck
of the year 2010 so that it has the same age as the rest of companions
in the selector
I will select female
in the hair color I will select
blond
in the color of eyes I will select
green
and street ...
my street ...
33
and I will leave the data by default and then observe in the case of
the phone as you see does not let me enter
nothing more than
agreement numbers?
and how do you see me represented with underscores
what we would have to introduce ... well in principle I'm going to put a
fictional phone
let's go back
here
926 444 444 ... well, I already have introduced
the new student ... the new student
Julia ... well ...
let's go to the design of the table ... we will select the date of birth ...
and in the sub options remember that we have here
the option to show the date selector of so that
I will never select
agree? then I will close ... I will save the changes
I'm going to open the table again
So you can see that the selection selector does not appear when the date is selected?
I'm going back to design
of Table and then we will focus on the input mask for the date of birth of the student
in principle, he should only
allow to write numbers well? in the input masks for the direct input of numbers
There are two characters ... okay? At first
we can
use the 9 for example
99/99/9999
99/99/9999
99/99/9999
it would be an optional entry mask
remember I'm doing it with the same mold of the date format that we have ... like
we have selected short date remember that the short date are two digits for the day
/ two digits for
the month / four digits for the agreed year?
then as I was saying the entrance mask the 9 in the entrance mask mean
have to enter for each 9 a digit or a number from 0 to 9
optionally
all right? that is, the user can write a digit or for every 9 that there is but does not require him to enter
in this case the 8 digits ... in agreement? so this would not be the most appropriate ...
let's check how it works
let's open the table students
and then I will delete March 20, 2010
and now I can put 20
I'm going to put for example just a 3 here
and of 2010
I pulse enter and as you see you have entered it but you have accepted me to introduce only and exclusively
one digit when I said that they are 2 since this is optional ... remember the 9
in the input masks is optional digit entry ... digit I mean numbers from 0 to 9
well, if we want it to be mandatory to have to introduce
these eight digits basically instead of using
the character 9 we should use the character 0 ie
00/00/0000
00/00/0000
00/00/0000
00/00/0000
all right? by doing so we are forcing
let's close and say yes
I'm going to open the table again
and I'm going to erase it again
this birth date of March 20
and then I will put 20, I will try to move, I will put a 3 and I will put 2010 by pressing enter as you see
He is giving me an error, he is telling me that I am not respecting the entrance mask
So with this you already have to be clear that every time you use a 9 in the input mask
is that you optionally allow the user to enter a number from 0 to 9
but we do use the character 0 we are
asking that it be mandatory
your fill then I will reselect it
and now when you enter 20 03 2010 and press enter I accept it perfectly
agree?
next I will go back to the design of the table
to clarify
already more in depth than
the entrance masks actually
When we introduce an input mask, the input masks must have
three separate parts
with semicolons (;) as is usual in Excel and Access also in other languages
but basically what I mean is that with this I'm defining the input mask
but there are other things that can be defined
for example
the 2nd paragraph after the (;) would be the one that allows me to indicate
if you have to store all the data or just those we have written
all right?
so here we only have the possibility to indicate it by means of a zero or a one ... if after the (;) that is to say in the second section
we enter a zero in the input mask this indicates that the characters of the mask will be stored with the data ie the
bars or any sign we would have written as constant, okay? in this case as
they are all of them, not only the 8 that we write but the two bars (/)
that is to say the ten characters, we want them to be stored here we would have to put after the (;) a zero
agree? below (;) because there is a third section
and you have already observed
when
we are introducing
the date actually
what we find
is that they appear at the bottom
underscores (_)
lines in the base of the characters that we are writing
if we wanted to change that character because that underline character is used by default, so we would have to
to do is after the second (;) that is, in the third section
introduce what character we want us to use in this case, for example
the script of agreement?
how do you see the first section
that is, until you reach the first (;)
we are defining the input mask after the first (;) or between the first and the second a zero means that the
characters that we have not introduced but that are in the mask
and after the second and last (;)
we put the character we want to appear
symbolizing that we must fill in ... in agreement?
press enter ... let's go to visualize ... let's save the table
and then when ...
we are going to erase this ... how do you see when you enter now the input mask is reflecting me
the characters that I have to fill out
with scripts so that we could write again the same
all right?
suppose we want to change them for a slightly more distinctive character, for example, use the (*) and we will put here
an asterisk ... press enter ... we return to visualize the table after saving it
and then I delete a date
observe that an asterisk appears for each character that I am asking
So this is not just for numbers remember that the masks are made up of three parts that allow us to select
or define what we want to be the characters that symbolize
the one that we have to introduce
a character in that position
and in this video you have to be clear that we are using
in the input mask or 9 or 0 ... if we use 9 it means that
are optional characters that the user will enter, that is, if you do not want to, you do not have to enter all of them
but if we put zeros we are forcing it to be exactly that amount
of numeric characters entered ... okay?
Well, we have already clarified this, I will initially leave it with a script instead of with an asterisk
and then we can look
the phone number ... in the phone number remember that we did
with 9 so that now with what we know
this tells us or you have to say that we are asking the user to enter nine
optional figures
so if I enter 4 the database would accept it
agree? if I introduce less
of which we are indicating here and we have said
or we said in his day that there was a space
after each block of three, to separate it as traditionally is usually done here
well, let's check that this is how we just talked
so that for example in the phone number of any student
if we delete the phone number here
we could enter 926 and give it to enter and we would have accepted it ... I'm going to expand it so that
you see it in full as you see and this is not a valid phone number so that
the entrance mask is not doing its full function and on the other hand
the underscores (_)
or the underline symbol indicates the three blocks of three that must be entered
good with what we already know
we will go
let's enter a new phone number because otherwise it does not comply ... here ... and then we will go
to the design of the table
we leave it as it is but in the entrance mask with what we already know we could say
to be mandatory the introduction of the nine-digit agreement?
we could say 000 would be mandatory script (-) because I want there to be a specific sign that in this case we do not want to save
000 - 000
agree? then;
and in this case I do not want to save
the data the scripts are saved so that so
in the second part of the input mask we should not use a 0
since this would do as in the previous case
save me those signs that I am using as constants so that here as is logical we will have to put 1
below (;) again
and the sign that we want to be used
as a fill-in selector
in this case for example I'm going to put the asterisk (*) again pulse enter
and then
let's see the table ... we will select the phone of the student Julia and we will delete it ... as you see here
the asterisks appear indicating that I have to enter nine digits
and among them the script ... the script remembers
we do not want it to be part of the mask that Reality is saved
basically just the number, so here we are going to fill in again 926 if I pulse
enter gives me an error because it tells me hey it does not match the mask that you've
indicated, the one you have specified so that what you intend to enter
does not comply with that data entry rule well?
clarified this we will continue to write the phone number
and press enter ... really inside the database
having put the 1 in the 2nd paragraph of the mask is not keeping me
the 11 digits, that is, the nine digits and the two dashes, not ...
If so, would it give us an error because? because this field we have defined as a number and a script as well you know is not part of that type of data
so in the 2nd section we have put a 1 so that only 926 keeps us
444 444 according? this information is very important and in future videos I will continue
deepening with the input masks since apart from having these two characters
to be able to enter
number ... digits from 0 to 9 both optionally
which are the movements, as in a mandatory way that are the zeros in the entrance mask we are
with that there are 10 or 12 more signs that we can use within the entrance mask not only these two and we will see them in future videos ...
Well that's it...
thank you very much for sharing my videos on your social networks ...
thanks for subscribing and for activating the notification bell ... thank you very much for your comments and for your Likes ... see you
in a new installment of your YouTube channel Infoductiva ... See you soon Infonaut ...
For more infomation >> Samsung J8 VS Samsung J6 | Enfrentamiento | Review | Unboxing - Duration: 15:18. 
For more infomation >> RE DOING MY BEAUTY ROOM | MY BEAUTY ROOM MAKEOVER - Duration: 9:11. 
For more infomation >> Правильная установка ванны, ремонт своими руками - Duration: 17:11. 
For more infomation >> Wynonna Earp Season 4 Teaser Promo (SUB ITA) - Duration: 0:15. 
For more infomation >> NOWY KANAŁ! 🔥 Billie Sparrow x Hania Es - Duration: 1:35. 
For more infomation >> Javzye - Consumed (Prod. Yung K.) #YBYouthBlood - Duration: 2:32. 
Không có nhận xét nào:
Đăng nhận xét