Re: [sqlite] "SQL Error: near 'Table': Syntax error"

[Dennis Cote]

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