On Jan 27, 2009, at 10:08 AM, Fred Williams wrote:

>
> Should not the GENERAL.ID be enclosed in double quotes?  Or did I  
> misread
> the SQL Standard?

You can use double-quotes to conform to the SQL standard.  But SQLite  
also allows some non-standard quoting mechanisms for compatibility  
with other database engines.   [...] is used by MS SQL Server.   `...`  
is used by MySQL.


D. Richard Hipp
d...@hwaci.com



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to