a local taxes 2013 shoot or ooze
this video gonna be looking bit more closely the WHERE condition
so you wanna play along follow the link below the video to determine search the
web site internet access 2013
the B-thirteen and then open up
are gone and the last video we look to the browse through the
mark correction and we looked at it for
the the four main riches
to and
for former Anthony riders you couldn't using the breast tumor correction we can
choose
to only display active rooms
all connected rooms all the rooms so
what we're looking at the today is drop in a combo box in here
and using this combo box to select
a different 4sec rooms on different floors so you can overcome a book to say
something like
to meaning floor number two in
the when you update the combo box who only display
rooms are on the second floor which start with the number two
so we're going to need to look at the poor condition
little bit to do that so open up
former arms and go to lay out for you
and let's drop this combo box in here design was the right one
to from here and
scored a good cooking is empty so
and split it a couple times we really want my comic books about the
okay so click a combo box and the striker
this change the label to
from floor and click on the comment box
press f4 go to other and change that to CB
no floor now the
values are going to in the comic book to let you gonna be 2345 is there the
flows we have so good data
resource type change it to valueless
clicking here click on the ellipsis and
2345 with an iPhone maybe receptions on the ground floor
player it's an interesting a mission
occurred first the floor
and if we go to form to you clicking here
so we're now able to actually choose which floor we will receive obviously we
don't have
the ability a moment to do anything refer
so in order to get this Stacy
to show what we would have to use the Browse to macro action against this is
quite an active
go to bed macro control
a control see closed for
floor wicked macro
control very and at the moment we've got exactly the same functionality
as on the active bottom bar
we obviously want to do something different with the where conditions were
guerrilla
so in order for this to work good thing about this logically
if we click on the number two what we wanna do is
only display rooms to begin
with the number two and if we update this to number three
we were only display yeah okay
we will only display rooms to begin with the number three
so how do we do that but what it means we need to do is we need to evaluate the
first character
say that if the first character equals three for example
but then save it doesn't matter
over how many characters are after three or what those characters are
so we do that using the light
keyword for clicking here and we don't want the
have made one mistake already sorry press Control
X favor but we're on the click oven or on the of the update I'm gonna use to
LIKE operator
so gonna say room
number Lisa believe that name in the field
and it's not equals it's going to be like
I'm in need per
a a single quotation mark Rica
and see bo2 floor
and ass throw
double quotation marks Asterix Asterix single quotation mark
double quotation mark onlookers took this works in an hour explain it
in order to check it works will have to go to for me
to say
work indeed okay
how they work
alright
the actual thing we're producing is
a sticky note to explain this
the actual exact assuming that the CBF losses
three that's exactly the statement passing
is room room
number like
I'm
3 sticks pressure okay
so remember but you get rich is by saying
remember needs to be and then we're not saying equals to
were saying like which were used to stream expressions
and the street because we're passing a string expression we need
quotation marks but not double quotation marks in this case single quotation
marks well good to that
too much just remember if you see the word like it needs to be followed by
some kind of expression in single quotation marks
the number three is from CBOT floor free cupcakes ego floated to you gonna get to
hussein like the number three and we've got Asterix and what the Asterix means
is any combination of any number of characters
after the number three and as it happens
who love the with the characters
with the room sorry have three digit so 301 302 so
you could for example used to question marks a question mark is
any character but single character but for the sake of
making a life simple we're just gonna go three and domestics
just to reiterate remembers the field a
like is what we use instead if
equals three we need to make use of comparison offer a broader than a
equals two means literally no I V Corps some your dozen
boers when we have some kind of tolerance in this case
with the number three will be fixed for anything he
is that we're gonna use like like takes a string
variable which means it needs to be in quotation marks
so is followed by so many single quotation marks not gonna go too much
into that
and just have to know what called Wild Card characters yesterday X's
any amount have any number of characters and another option
is to question mark which would be any character but only represented a single
character
XLS this way condition and that's how you can use
the LIKE operator nowhere condition to a
achieve what we wanted to which was to update the
datasheet only sure rooms from self-love so thank you for watching a see you next
year