Re: [sqlite] Two simple questions

2009-06-24 Thread Robert Simpson
You'll have to call sqlite3_column_name() in a loop to find the named column returned from a prepared select statement. As for the default values, to get that information you'll have to execute a "PRAGMA TABLE_INFO(tablename)" query and examine the 5th column "dflt_value" for the row matching the

Re: [sqlite] Two simple questions

2009-06-24 Thread P Kishor
On Wed, Jun 24, 2009 at 12:18 PM, Shaun Seckman (Firaxis) wrote: > Just two quick and simple questions :) > > > >                In a prepared statement, is there a quick way to > determine what the index of a column with a specific name is or must I > just iterate through all columns and perform a