The AND/OR operators work equally well as boolean (logical) operators, it's only the NOT operator which has a difference.
Note that with boolean operators you should only use 1 and 0 (true and false) as an input.
I agree that the help files are in error, as they explicitly state:
Quote: "The NOT operator works using the following table. This operator is a unary operator and only requires a single right-side value:
NOT 0 = 1
NOT 1 = 0"
But for some reason AND behaves like &&, OR behaves like || and NOT behaves like ..
The easiest way of fixing it is to do the following:
function logicalNOT(a as boolean)
a = 1 - a
endfunction a
Even though there's still a workaround, it's one of the most commonplace bugs in DBPro, and should be fixed.
The optomist's right, The pessimist's right.