On 3 Jul 2014, at 10:22pm, Martin Kleusberg <mkleusb...@gmail.com> wrote:

> I've encountered some odd behaviour when using the sqlite3_column_name 
> function.

Sorry, but column names are guaranteed only if you use an 'AS' clause in your 
SELECT command.  For every other situation, there's no telling what you'll get. 
 For instance

SELECT fred FROM MyTable

may return with a column name of 'fred' or 'main.fred'.

If you're using column names in your programming, always do

SELECT fred AS fred FROM MyTable

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to