and/or statement

[P Lee]

Can you clarify what does this statement mean, as I'm getting really confused with the and/or:

if InStr(Label2.Caption, "SSL + SET") And _
InStr(Label2.Caption, "digital cash") Or _
InStr(Label2.Caption, "SSL + SET") Then

Does it mean if either SSL + digital cash is selected then.....?

Thanks.

[MarkT]

If the caption contains "SSL + SET" And it also contains "digital cash"

or if the caption contains "SSL + SET" then

do something.

[Bruce Fox]

Originally posted by P Lee
Can you clarify what does this statement mean, as I'm getting really confused with the and/or:

if InStr(Label2.Caption, "SSL + SET") And _
InStr(Label2.Caption, "digital cash") Or _
InStr(Label2.Caption, "SSL + SET") Then

Does it mean if either SSL + digital cash is selected then.....?

Thanks.

IF "SSL + SET" And "digital cash" is found, Or "SSL + SET" is found, Then....

[peet]

Private Sub Form_Load()
Label2.Caption = "SSL + SET" & "digital cash"
 
'the first instr will return 1
'the second instr will return 10
'if u do a And operation on 1 And 10 it will return 0 (false)
 
If InStr(Label2.Caption, "SSL + SET") And _
InStr(Label2.Caption, "digital cash") Or _
InStr(Label2.Caption, "SSL + SET") Then
    MsgBox "sdfasd"
End If
MsgBox 1 And 10
 
'u should do it like this :
If InStr(Label2.Caption, "SSL + SET") <> 0 And _
InStr(Label2.Caption, "digital cash") <> 0 Then
'.
'.
 
End Sub

[peet]

I tried to explain, but if this is somewhat unclear, let me know

[P Lee]

thanks, in that case I want both options to be selected so I'll use:

if InStr(Label2.Caption, "SSL + SET") And _
InStr(Label2.Caption, "digital cash") and then

[Heribertt]

The AND statement "SSL , SET"
by the And statement must by the SSL and the SET condition or value TRUE
by the Or statement must one value by true the SSL or the SET

that is the different between these two

[peet]

[Bruce Fox]

Originally posted by peet

'u should do it like this :
If InStr(Label2.Caption, "SSL + SET") <> 0 And _
InStr(Label2.Caption, "digital cash") <> 0 Then

Good point Peet, I missed that

[peet]

only reason i knew is because I'v done the same thing... wish I only did it once though

[P Lee]

sorry guys, but what does the <> actually mean in the suggested recommended code:

If InStr(Label2.Caption, "SSL + SET") <> 0 And _
InStr(Label2.Caption, "digital cash") <> 0 Then

Does it mean if both are selected then........?

If I just done this, then what is the difference?

If InStr(Label2.Caption, "SSL + SET") And _
InStr(Label2.Caption, "digital cash") > 0 Then

[peet]

the problem is that u do a boolean operation on two integers

eg 1 And 10 ... it does not give u the result u want.

1 And 10 returns 0 (false)

if u add the <> 0 then u do a operation on two expressions that either return 1 or 0

then u get the expected result...

1 And 1 = 1

1 And 0 = 0

.
.
.


damn! I'm having problems explaining this

could anyone better in english do it for me please

[Wokawidget]

It doesn't matter.
VB interprets 0 as False and ANYTHING else as TRUE!

1 AND 0 = FALSE
1 OR 0 = TRUE
1 AND 15 = TRUE
0 AND 15 = FALSE
42 OR 0 =TRUE



Does that make sense?

So if:

InStr(Label2.Caption, "SSL + SET")

is greater than 0 then it's TRUE

[darre1]

instead of

If InStr(Label2.Caption, "SSL + SET") <> 0 And InStr(Label2.Caption, "digital cash") <> 0 Or _
    InStr(Label2.Caption, "SSL + SET") <> 0 Then
    MsgBox "sdfasd"
End If

i would usually use brackets to make it more readable. i.e.

If [b]([/b]InStr(Label2.Caption, "SSL + SET") <> 0 And InStr(Label2.Caption, "digital cash") <> 0[b])[/b] Or _
    InStr(Label2.Caption, "SSL + SET") <> 0 Then
    MsgBox "sdfasd"
End If

although in the above example you dont need the And bit anyway, it can be left as

If InStr(Label2.Caption, "SSL + SET") <> 0 Or _
    InStr(Label2.Caption, "SSL + SET") <> 0 Then
    MsgBox "sdfasd"
End If

[Wokawidget]

Don't you mean:

If (InStr(Label2.Caption, "digital cash") Or _
    InStr(Label2.Caption, "SSL + SET")) Then
    MsgBox "sdfasd"
End If

[P Lee]

Thanks guys I understand now.

[darre1]

Originally posted by Wokawidget
Don't you mean:

If (InStr(Label2.Caption, "digital cash") Or _
    InStr(Label2.Caption, "SSL + SET")) Then
    MsgBox "sdfasd"
End If

nope

[peet]

Originally posted by Wokawidget
It doesn't matter.
VB interprets 0 as False and ANYTHING else as TRUE!

1 AND 0 = FALSE
1 OR 0 = TRUE
1 AND 15 = TRUE
0 AND 15 = FALSE
42 OR 0 =TRUE



Does that make sense?

So if:

InStr(Label2.Caption, "SSL + SET")

is greater than 0 then it's TRUE

Private Sub Command1_Click()
    MsgBox 1 And 12 '( 1 And 1100 = 0
    MsgBox 1 And 13 '( 1 and 1101 = 1
    MsgBox 1 And 14 '( 1 and 1110 = 0
    MsgBox 1 And 15 '( 1 and 1111 = 1
    MsgBox 1 And 16 '( 1 and 10001 = 0
End Sub

I assume u agree to this ?

It does matter what u And with what ...

[Wokawidget]

Originally posted by darre1
...although in the above example you dont need the And bit anyway, it can be left as

If InStr(Label2.Caption, "SSL + SET") <> 0 Or _
    InStr(Label2.Caption, "SSL + SET") <> 0 Then
    MsgBox "sdfasd"
End If

errrr...doest this equate to:

If InStr(Label2.Caption, "SSL + SET") <> 0 Then
    MsgBox "sdfasd"
End If

(a AND b) OR b = a OR b
b OR b = b
(a OR b) AND b = b
(a AND b) AND b = a AND b


Good old kaunaugh maps...spelling is incorrect

[darre1]

Originally posted by Wokawidget


errrr...doest this equate to:

If InStr(Label2.Caption, "SSL + SET") <> 0 Then
    MsgBox "sdfasd"
End If

oops