David Champagne wrote:
If I have a table defined in the following manner
CREATE TABLE License (Form varchar(256), Type int, NbOcc int)
and then I execute a query
SELECT * FROM License WHERE FORM = "form";
I get all rows returned, even though I only want the rows where the
column FORM contains the string "form". Any idea if this is a problem
in the definition of the query or a bug in SQLite?
I am using SQLite version 3.2.2
Thanks
The query you are looking for is
SELECT * FROM License WHERE FORM = 'form';
Strings should be enclosed with single quote.
Double quoted strings are interpreted as column names; if there isn't a column with that name, then they are interpreded as strings.
Paolo
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------