Hi Dennis, thanks for this, I've just spent the last 30 mins typing in every word I could think of that might have come up with a conflict, it was nowhere near as big as the list in the link.
Thanks for the tips. John On 26/07/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
John Newby wrote: > > Is there any other names I need to look out for other than the > "sqlite_" and > "table" that SQLite doesn't like as being a table name that anyone > knows of? > John, All keywords need to be quoted to use them as identifiers. There is a comprehensive list of keywords at http://www.sqlite.org/lang_keywords.html I would also suggest that you stick with the SQL standard method of quoting identifiers using double quotes (rather than the other extensions that SQLite accepts for compatibility with other non-standard database systems). HTH Dennis Cote
