Why this doesnt work? Operators "And" "Or"

[nbala75]

I have been reading the help file and forum for a problem iam facing for 2 days now

Even after searching, iam unable to figure out what exactly is wrong in my statement

Pls help me

If $tradelogTableData[4][$lastcol]=$aCellValue And $tradelogTableData[3][$lastcol]=StringLeft($dCellValue,1) _
And $tradelogTableData[5][$lastcol]<$cCellValue And ($tradelogTableData[6][$lastcol]=$LP or $tradelogTableData[6][$lastcol]=$TP) Then
       Msgbox(0,"","")

Iam sure that there are some errors in "OR" part. I have even used brackets to force it. But still iam not getting it through. This seems to be simple but never works for me !

I tried this as well...this also doesnt work !!

If $tradelogTableData[4][$lastcol]=$aCellValue And $tradelogTableData[3][$lastcol]=StringLeft($dCellValue,1) _
And $tradelogTableData[5][$lastcol]<$cCellValue Then
        If $tradelogTableData[6][$lastcol]=$LP or $tradelogTableData[6][$lastcol]=$TP Then
              Msgbox(0,"","")

The input values which i checked using a msgbox just before these statements were:

$tradelogTableData[4][$lastcol]=AAA

$aCellValue= AAA

$tradelogTableData[3][$lastcol]=S

StringLeft($dCellValue,1) =S

And $tradelogTableData[5][$lastcol]=209

$cCellValue=234

$tradelogTableData[6][$lastcol]=213.55

$LP =213.55

$tradelogTableData[6][$lastcol]=213.55

$TP=213.55

Edited July 10, 2012 by nbala75

[Mechaflash]

I don't see a statement anywhere, I only see strings

Did you forget your "if" ?

If you didn't forget it in your actual code, then please post your actual code.

[rvn]

simple example here

;if all true
If 1 = 1 And 1 = 1 And 1 = 1 And (1 = 1 Or 1 = 1) Then
ConsoleWrite("IF return TRUE" & @CRLF)
Else
ConsoleWrite("IF return FALSE" & @CRLF)
EndIf

;if something false in "AND"
If 1 = 0 And 1 = 1 And 1 = 1 And (1 = 1 Or 1 = 1) Then
ConsoleWrite("IF return TRUE" & @CRLF)
Else
ConsoleWrite("IF return FALSE" & @CRLF)
EndIf

;if something false in "OR"
If 1 = 1 And 1 = 1 And 1 = 1 And (1 = 0 Or 1 = 1) Then
ConsoleWrite("IF return TRUE" & @CRLF)
Else
ConsoleWrite("IF return FALSE" & @CRLF)
EndIf


;Result
;IF return TRUE
;IF return FALSE
;IF return TRUE

is this what u want?!

[nbala75]

I don't see a statement anywhere, I only see strings

Did you forget your "if" ?

If you didn't forget it in your actual code, then please post your actual code.

Not copy pasted correctly....edited now

[nbala75]

simple example here

;if all true
If 1 = 1 And 1 = 1 And 1 = 1 And (1 = 1 Or 1 = 1) Then
ConsoleWrite("IF return TRUE" & @CRLF)
Else
ConsoleWrite("IF return FALSE" & @CRLF)
EndIf

;if something false in "AND"
If 1 = 0 And 1 = 1 And 1 = 1 And (1 = 1 Or 1 = 1) Then
ConsoleWrite("IF return TRUE" & @CRLF)
Else
ConsoleWrite("IF return FALSE" & @CRLF)
EndIf

;if something false in "OR"
If 1 = 1 And 1 = 1 And 1 = 1 And (1 = 0 Or 1 = 1) Then
ConsoleWrite("IF return TRUE" & @CRLF)
Else
ConsoleWrite("IF return FALSE" & @CRLF)
EndIf


;Result
;IF return TRUE
;IF return FALSE
;IF return TRUE

is this what u want?!

I do see something like this works...but mine(in my first post) is also similar...why it doesnt work??

$A=1
$B=1

$c=5
$D=5

$E=10
$F=10

$G=100
$LP=100
$TP=500

;if all true
If $A = $B And $c = $D And $E = $F And ($G = $LP Or $G = $TP) Then
ConsoleWrite("IF return TRUE" & @CRLF)
Else
ConsoleWrite("IF return FALSE" & @CRLF)
EndIf

[rvn]

"why it doesnt work??", well it work for me... nothing wrong with the logic, or maybe that script is not what you need

[John]

If any of those variables are returning a value that is padded with a whitespace new line character will fail. Such characters will not be visible on a MsgBox either. I sometimes, for debugging, append characters before and after variables that look right but might not be. Such as:

MsgBox(0,"","|" & $var & "|")

This will make spaces and such visible.

[rvn]

If any of those variables are returning a value that is padded with a whitespace new line character will fail. Such characters will not be visible on a MsgBox either. I sometimes, for debugging, append characters before and after variables that look right but might not be. Such as:

MsgBox(0,"","|" & $var & "|")

This will make spaces and such visible.

ofcourse it is not. its all about parsing the string to "IF" decision... here for example

; example right logic but wrong implementation
$var = " " & @CRLF & " "
;ConsoleWrite("'" & $var & "'" & @CRLF)
$var = StringStripWS($var, 1+2)
;ConsoleWrite("'" & $var & "'" & @CRLF)

If $var = @CRLF Then
ConsoleWrite("IF return TRUE" & @CRLF)
Else
ConsoleWrite("IF return FALSE" & @CRLF)
EndIf

; example right logic and right implementation
$var = " " & @CRLF & " "
;ConsoleWrite("'" & $var & "'" & @CRLF)
$var = StringTrimRight($var,1)
$var = StringTrimLeft($var,1)
;ConsoleWrite("'" & $var & "'" & @CRLF)

If $var = @CRLF Then
ConsoleWrite("IF return TRUE" & @CRLF)
Else
ConsoleWrite("IF return FALSE" & @CRLF)
EndIf

;Result
;IF return FALSE
;IF return TRUE