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. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users