On 15/09/14 19:28, lchis...@paradise.net.nz wrote: > I have been caught several times when a previously working piece of SQL has > silently failed, due to a column or view change in the database not matched > with > a Delphi code change, an inadvertent character injection into a column name, > or > when placing double quotes around a tablename.columnname in the Delphi source > for tidyness/completeness I have put quotes around the whole thing rather than > the individual elements.
I've been pushing for a "lint mode" where SQlite would flag this and similar issues. It would help developers for testing and result in more robust code using SQLite. To amuse yourself try doing a "natrual" join (sic) sometime! Sadly the SQLite team rejected it: http://www.sqlite.org/src/tktview?name=25e09aa2ab Roger _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
