AnsweredAssumed Answered

Or Problem

Question asked by firebase on Sep 14, 2014
Latest reply on Sep 15, 2014 by philmodjunk

Title

Or Problem

Post

I am not good in logical operator, so i guees this is a problem of my fundamental understanding.

Wenn i do:

1=1

or

1=2

It results into true, because one of either is true.

But when i do a more complicated SQL forumlar it does not work the same way.

Like

table1::field  ≠  ExecuteSQL ("SELECT field1 FROM table2 WHERE field2 = ? " ;"";""; table3::field )

or

table4::field  ≠  ExecuteSQL ("SELECT field1 FROM table5 WHERE field2 = ? " ;"";""; table5::field )

What i used is more complicated but anyway, both sides work for itself but as soon i use both and place the or in between it does not work anymore. I also tried Not before the first liune and eafter the or instead of ≠ and using =.

 

 

Outcomes