1
00:00:01,280 --> 00:00:03,759
a local taxes 2013 shoot or ooze

2
00:00:03,759 --> 00:00:07,838
this video gonna be looking bit more closely the WHERE condition

3
00:00:07,839 --> 00:00:11,320
so you wanna play along follow the link below the video to determine search the

4
00:00:11,320 --> 00:00:13,548
web site internet access 2013

5
00:00:13,548 --> 00:00:16,969
the B-thirteen and then open up

6
00:00:16,969 --> 00:00:20,809
are gone and the last video we look to the browse through the

7
00:00:20,809 --> 00:00:25,439
mark correction and we looked at it for

8
00:00:25,439 --> 00:00:28,879
the the four main riches

9
00:00:28,879 --> 00:00:32,089
to and

10
00:00:32,090 --> 00:00:36,180
for former Anthony riders you couldn't using the breast tumor correction we can

11
00:00:36,179 --> 00:00:36,890
choose

12
00:00:36,890 --> 00:00:40,250
to only display active rooms

13
00:00:40,250 --> 00:00:44,909
all connected rooms all the rooms so

14
00:00:44,909 --> 00:00:49,679
what we're looking at the today is drop in a combo box in here

15
00:00:49,679 --> 00:00:52,679
and using this combo box to select

16
00:00:52,679 --> 00:00:56,979
a different 4sec rooms on different floors so you can overcome a book to say

17
00:00:56,979 --> 00:00:57,750
something like

18
00:00:57,750 --> 00:01:00,859
to meaning floor number two in

19
00:01:00,859 --> 00:01:04,618
the when you update the combo box who only display

20
00:01:04,618 --> 00:01:07,868
rooms are on the second floor which start with the number two

21
00:01:07,868 --> 00:01:11,400
so we're going to need to look at the poor condition

22
00:01:11,400 --> 00:01:14,420
little bit to do that so open up

23
00:01:14,420 --> 00:01:18,890
former arms and go to lay out for you

24
00:01:18,890 --> 00:01:24,469
and let's drop this combo box in here design was the right one

25
00:01:24,469 --> 00:01:27,950
to from here and

26
00:01:27,950 --> 00:01:33,030
scored a good cooking is empty so

27
00:01:33,030 --> 00:01:37,070
and split it a couple times we really want my comic books about the

28
00:01:37,069 --> 00:01:40,949
okay so click a combo box and the striker

29
00:01:40,950 --> 00:01:44,040
this change the label to

30
00:01:44,040 --> 00:01:48,649
from floor and click on the comment box

31
00:01:48,649 --> 00:01:52,439
press f4 go to other and change that to CB

32
00:01:52,438 --> 00:01:56,508
no floor now the

33
00:01:56,509 --> 00:02:01,118
values are going to in the comic book to let you gonna be 2345 is there the

34
00:02:01,118 --> 00:02:04,129
flows we have so good data

35
00:02:04,129 --> 00:02:08,340
resource type change it to valueless

36
00:02:08,340 --> 00:02:12,509
clicking here click on the ellipsis and

37
00:02:12,509 --> 00:02:19,318
2345 with an iPhone maybe receptions on the ground floor

38
00:02:19,318 --> 00:02:22,378
player it's an interesting a mission

39
00:02:22,378 --> 00:02:26,549
occurred first the floor

40
00:02:26,550 --> 00:02:31,330
and if we go to form to you clicking here

41
00:02:31,330 --> 00:02:35,370
so we're now able to actually choose which floor we will receive obviously we

42
00:02:35,370 --> 00:02:36,090
don't have

43
00:02:36,090 --> 00:02:39,420
the ability a moment to do anything refer

44
00:02:39,419 --> 00:02:44,268
so in order to get this Stacy

45
00:02:44,269 --> 00:02:48,330
to show what we would have to use the Browse to macro action against this is

46
00:02:48,330 --> 00:02:49,420
quite an active

47
00:02:49,419 --> 00:02:54,429
go to bed macro control

48
00:02:54,430 --> 00:02:58,950
a control see closed for

49
00:02:58,949 --> 00:03:02,780
floor wicked macro

50
00:03:02,780 --> 00:03:09,560
control very and at the moment we've got exactly the same functionality

51
00:03:09,560 --> 00:03:15,509
as on the active bottom bar

52
00:03:15,509 --> 00:03:17,919
we obviously want to do something different with the where conditions were

53
00:03:17,919 --> 00:03:18,628
guerrilla

54
00:03:18,628 --> 00:03:21,780
so in order for this to work good thing about this logically

55
00:03:21,780 --> 00:03:25,400
if we click on the number two what we wanna do is

56
00:03:25,400 --> 00:03:28,860
only display rooms to begin

57
00:03:28,860 --> 00:03:33,180
with the number two and if we update this to number three

58
00:03:33,180 --> 00:03:36,920
we were only display yeah okay

59
00:03:36,919 --> 00:03:40,579
we will only display rooms to begin with the number three

60
00:03:40,580 --> 00:03:44,540
so how do we do that but what it means we need to do is we need to evaluate the

61
00:03:44,539 --> 00:03:45,759
first character

62
00:03:45,759 --> 00:03:50,120
say that if the first character equals three for example

63
00:03:50,120 --> 00:03:55,019
but then save it doesn't matter

64
00:03:55,019 --> 00:03:58,709
over how many characters are after three or what those characters are

65
00:03:58,709 --> 00:04:01,759
so we do that using the light

66
00:04:01,759 --> 00:04:05,818
keyword for clicking here and we don't want the

67
00:04:05,818 --> 00:04:09,188
have made one mistake already sorry press Control

68
00:04:09,188 --> 00:04:16,188
X favor but we're on the click oven or on the of the update I'm gonna use to

69
00:04:21,180 --> 00:04:22,250
LIKE operator

70
00:04:22,250 --> 00:04:28,069
so gonna say room

71
00:04:28,069 --> 00:04:32,349
number Lisa believe that name in the field

72
00:04:32,350 --> 00:04:37,550
and it's not equals it's going to be like

73
00:04:37,550 --> 00:04:40,780
I'm in need per

74
00:04:40,779 --> 00:04:44,909
a a single quotation mark Rica

75
00:04:44,910 --> 00:04:49,310
and see bo2 floor

76
00:04:49,310 --> 00:04:52,879
and ass throw

77
00:04:52,879 --> 00:04:56,978
double quotation marks Asterix Asterix single quotation mark

78
00:04:56,978 --> 00:05:01,800
double quotation mark onlookers took this works in an hour explain it

79
00:05:01,800 --> 00:05:07,560
in order to check it works will have to go to for me

80
00:05:07,560 --> 00:05:12,889
to say

81
00:05:12,889 --> 00:05:15,539
work indeed okay

82
00:05:15,540 --> 00:05:22,540
how they work

83
00:05:25,199 --> 00:05:28,709
alright

84
00:05:28,709 --> 00:05:31,698
the actual thing we're producing is

85
00:05:31,699 --> 00:05:35,189
a sticky note to explain this

86
00:05:35,189 --> 00:05:40,729
the actual exact assuming that the CBF losses

87
00:05:40,728 --> 00:05:44,868
three that's exactly the statement passing

88
00:05:44,869 --> 00:05:51,270
is room room

89
00:05:51,269 --> 00:05:55,008
number like

90
00:05:55,009 --> 00:05:58,759
I'm

91
00:05:58,759 --> 00:06:02,270
3 sticks pressure okay

92
00:06:02,269 --> 00:06:05,498
so remember but you get rich is by saying

93
00:06:05,499 --> 00:06:09,619
remember needs to be and then we're not saying equals to

94
00:06:09,619 --> 00:06:13,279
were saying like which were used to stream expressions

95
00:06:13,278 --> 00:06:16,588
and the street because we're passing a string expression we need

96
00:06:16,588 --> 00:06:20,158
quotation marks but not double quotation marks in this case single quotation

97
00:06:20,158 --> 00:06:21,908
marks well good to that

98
00:06:21,908 --> 00:06:26,629
too much just remember if you see the word like it needs to be followed by

99
00:06:26,629 --> 00:06:29,338
some kind of expression in single quotation marks

100
00:06:29,338 --> 00:06:35,088
the number three is from CBOT floor free cupcakes ego floated to you gonna get to

101
00:06:35,088 --> 00:06:40,550
hussein like the number three and we've got Asterix and what the Asterix means

102
00:06:40,550 --> 00:06:43,610
is any combination of any number of characters

103
00:06:43,610 --> 00:06:47,449
after the number three and as it happens

104
00:06:47,449 --> 00:06:51,228
who love the with the characters

105
00:06:51,228 --> 00:06:56,058
with the room sorry have three digit so 301 302 so

106
00:06:56,059 --> 00:06:59,939
you could for example used to question marks a question mark is

107
00:06:59,939 --> 00:07:03,990
any character but single character but for the sake of

108
00:07:03,990 --> 00:07:07,639
making a life simple we're just gonna go three and domestics

109
00:07:07,639 --> 00:07:11,379
just to reiterate remembers the field a

110
00:07:11,379 --> 00:07:14,528
like is what we use instead if

111
00:07:14,528 --> 00:07:19,399
equals three we need to make use of comparison offer a broader than a

112
00:07:19,399 --> 00:07:22,889
equals two means literally no I V Corps some your dozen

113
00:07:22,889 --> 00:07:26,838
boers when we have some kind of tolerance in this case

114
00:07:26,838 --> 00:07:29,939
with the number three will be fixed for anything he

115
00:07:29,939 --> 00:07:33,278
is that we're gonna use like like takes a string

116
00:07:33,278 --> 00:07:36,689
variable which means it needs to be in quotation marks

117
00:07:36,689 --> 00:07:40,269
so is followed by so many single quotation marks not gonna go too much

118
00:07:40,269 --> 00:07:40,899
into that

119
00:07:40,899 --> 00:07:45,098
and just have to know what called Wild Card characters yesterday X's

120
00:07:45,098 --> 00:07:48,139
any amount have any number of characters and another option

121
00:07:48,139 --> 00:07:53,139
is to question mark which would be any character but only represented a single

122
00:07:53,139 --> 00:07:53,819
character

123
00:07:53,819 --> 00:07:58,180
XLS this way condition and that's how you can use

124
00:07:58,180 --> 00:08:01,819
the LIKE operator nowhere condition to a

125
00:08:01,819 --> 00:08:06,990
achieve what we wanted to which was to update the

126
00:08:06,990 --> 00:08:12,490
datasheet only sure rooms from self-love so thank you for watching a see you next

127
00:08:12,490 --> 00:08:12,740
year