Stef Mientki wrote:
I don't know if this is the problem, but, for some reason you're
mixing C/C++ syntax in with SQL there.
You don't use '==', you should just use '='
You don't use '!=', you should use '<>'
thanks Paul,
but although I can never find this information when I need it :-(
AFAIK, both notations are allowed.
Besides that I tried both and it doesn't change the situation.
Paul and Stef,
Being a C programmer, Richard extended SQLite to allow C syntax for
equality and inequality comparisons as shown at
http://www.sqlite.org/lang_expr.html even though it is non standard. If
you want your SQL code to be portable to other database engines you
should use the standard syntax that Paul suggested.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
