Anyone know how I can query the field names and types for a given table?
Jim,
select sql from sqlite_master where type="table" and name="gigo"
will get something like:
create table gigo(a,b,c)
which includes the field names, and would include the types if I had used any.
Gerry
