Thank you,
pragma is perfect!
Alessio Forconi
Il 12/03/12 22:47, Roger Binns ha scritto:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 12/03/12 14:42, Alessio Forconi wrote:
I am a novice with SQLite and I wonder if there is a select that
returns the names of the fields in the table?
You most likely want pragma table_info:
http://www.sqlite.org/pragma.html#pragma_table_info
If you have a SELECT then you can see what the associated names for each
column of the result are by using sqlite3_column_name:
http://www.sqlite.org/c3ref/column_name.html
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
iEYEARECAAYFAk9ebw4ACgkQmOOfHg372QT26QCg1xAarj3w+VlOC6mVJECB22tP
WugAoJvHsA12DNPEtEw5I713efjRpxoB
=Y8Gn
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users