I am contemplating something on similar lines. Just wanted to make sure that I am not trying to reinvent the wheel.
Thanks! On 10/26/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Ever Green <[EMAIL PROTECTED]> wrote: > I am using sqlite3_column_text16 to retrieve data. > > The problem is that sqlite3_column_text16 takes the column number as > argument. This breaks my existing code if I insert new columns in the > beginning of the column list that was specified in the SELECT > statement. Unfortunately, there is no lookup from column name to index, but there is one from index to name: see sqlite3_column_count, sqlite3_column_name[16], sqlite3_column_origin_name[16] . Not as convenient, but you can enumerate all column names and determine how those you want map to indexes. Igor Tandetnik ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------