On Sat, Jun 7, 2014 at 5:16 AM, David Q. <[email protected]> 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? I
> don't see this documented anywhere.
>
No. For a multi-column primary key, the columns that are part of the
primary key are numbered 1, 2, 3, 4, etc, according to which column they
are in the primary key.
For single-column primary keys, they value will always be 1, yes.
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
