hi,
using current cvs head, using the NOT_IN operator on criteria result in an
query:
SELECT ... FROM TABLE1 A0 WHERE NOT (A0.ATTR NOT IN (?,?))
[ the sql was captures with spy ]
as we see, a the NOT IN claise is negated, NOT is put in front of it, my
guess is that two implementations have been mixed, one that results in a
query like
SELECT ... FROM TABLE1 A0 WHERE A0.ATTR NOT IN (?,?)
and one that results in a query like
SELECT ... FROM TABLE1 A0 WHERE NOT (A0.ATTR IN (?,?))
hope this helps the guy who needs to fix this.
Roger Janssen
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
