On 26 Oct 2019, at 4:44am, Keith Medcalf <[email protected]> wrote:
> If the identifier is also a keyword and used in a location where it could be > that keyword Actually, any location. A SQL parser may pick out a SQL keyword even if it's in the wrong place in the wrong kind of SQL statement. And then issue a syntax error. You have a good point. So the options are these: A) quote all your entity names B) avoid using keywords in your entity names My personal style leans to one of these, but I suppose someone else's may lean to the other. (Obligatory note: although double quotes (undirected speech marks) are preferred, SQLite also understands square brackets and backward apostrophes.) _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
