Don't depend on column names. The ability to get a column name is not a fundamental part of the SQL specification. There is no standard for the text of column names, or for disambiguating names which occur in two different tables.
If you need to specify the units of a measurement, store them in their own column. Or create a standard which stores measurements as text in the format quantity<space>unit Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

