Ah, that works just fine.
Is this noted someplace in the documentation that I missed?
If not:
- why does it work with single quotes and not double? - Shouldn't it be added?
<snip>
Double quotes and single quotes have different meanings in SQLite (as defined in ANSI SQL too).
To produce string literals you MUST use single quotes.
Double quotes are used to specify case sensitive field/table/etc names, or variable names with spaces in them. This is the same as Microsoft's SQLs [] characters, or MySQL backquote characters (neither are ANSI standard by the way).
Therefore "bob" means the field name bob, and 'bob' means the literal bob.
Eddy
