I have noticed what appears to be an inconsistency of returned field names.
Two queries accessing the same field in the same table are returning slightly different field names. I don't know if this is by design or by accident and I'm simply reporting what I see. ________________________________________________________________ QUERY1: ------- "SELECT [categoryIndex] FROM CategoriesContent WHERE [contentIndex] = %i ORDER BY [categoryIndex] ASC;"; --> returns a field name of "categoryIndex". ________________________________________________________________ QUERY2: ------- "SELECT DISTINCT [categoryIndex] FROM CategoriesContent WHERE [new] = 1 ORDER BY [categoryIndex] ASC;"; --> returns a field name of "[categoryIndex]". ________________________________________________________________ I am using SQLite3 version 3.5.4. Lee Crain _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
