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