Many thanks again Igor.
On 16/11/2010 13:15, Igor Tandetnik wrote: > Ian Hardingham<i...@omroth.com> wrote: >> Thanks Igor. Can i get custom results like >> >> GamesWonByPlayer1 >> >> By using getColumn in the normal way? > I'm not familiar with the term "custom result". GamesWonByPlayer1 is just a > column alias which a) is completely optional, you could safely drop it from > the query (I've just included it for clarity), and b) does not in any way > interfere with sqlite3_column_* API (on which, I guess, getColumn is based in > whatever language binding you are using). > >> That may be a stupid question - I guess what I mean is, are those custom >> identifiers treated as column names when reading back from the select? > Basically, yes. With SQLite, you could address a column by name or by > position (numbered left to right starting from 0). Column alias in the query > makes it more convenient to do the former. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users