David Q. wrote: > I get columns names in a table by executing the query > > pragma table_info('the_table_name'); > > and using > > sqlite3_column_text(&ps,1) //index 1 = name > > for each row in the result set. > > This works, but can I rely on the index being 1 for the 'name' column?
It's very unlikely that this will be changed, because it might break any program (like yours) that relies on the column index. In any case, you can rely on the column name being "name". Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users