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]

-----------------------------------------------------------------------------


Reply via email to