On 8 Jan 2011, at 9:09am, Peter wrote: > So the 'column name' may be some internal representation/magic number > and bear no direct relationship to the name in the projector as supplied > in the SELECT?
For columns which are exact copies of columns in a table, the name is always a copy of the table's column name. You can rely on that. For columns which are the results of a calculation, there is no documentation for the name produced by SQLite. Different versions of SQLite may produce different names. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
