Hi Henri,
On 18.10.2005, at 14:56, Eggert, Henri wrote:
I have found that the problem is the column name "Text".
If I replace the column name "Text" by another all works fine.
So I wonder : is "Text" a keyword for sqlite ?
It indeed is [1]. :)
-Markus
[1] http://www.sqlite.org/datatype3.html
-----Ursprüngliche Nachricht-----
Von: Gerald Dachs [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 18. Oktober 2005 14:50
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] and , or
Hi sqlite-users
Works fine : select Id from Data where ( ( Text = '' ) or
( Comming = ''
) )
But NOT : select Id from Data where ( ( Text = '' ) and
( Comming '' )
)
What about this: select Id from Data where ( ( Text = '' ) and
( Comming =
'' ))
Gerald
---
Markus W. Weissmann
http://www.mweissmann.de/
http://www.opendarwin.org/~mww/
