On 08/01/11 09:12, Simon Slavin wrote: > > 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 > >
That sounds better. I just have to always use an AS clause on calculated fields. Maybe the documentation should be clarified? Pete -- Peter Hardman 'For every complex problem there is a solution that is simple, straightforward - and wrong' _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
