Re: [sqlite] ColType lost

2007-09-05 Thread Kees Nuyt
On Wed, 5 Sep 2007 10:54:55 +0200, Andre wrote: > I use sqlite3_column_type so the SQLITE_NULL > may actually be on a different [row] than the > one that actually has data, I will keep > investigating and report back, I might have > to use ... sqlite3_column_type() on every row you

RE: [sqlite] ColType lost

2007-09-05 Thread Andre du Plessis
be on a different one than the one that actually has data, I will keep investigating and report back, I might have to use -Original Message- From: Andre du Plessis [mailto:[EMAIL PROTECTED] Sent: 05 September 2007 10:08 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] ColType lost Should I

RE: [sqlite] ColType lost

2007-09-05 Thread Andre du Plessis
: [sqlite] ColType lost "Andre du Plessis" <[EMAIL PROTECTED]> wrote: > > I use the API as always: > > ColType := sqlite3_column_type(Pointer(FHandle), I); > > This has always worked fine for me and type returned was SQLITE_TEXT > If sqlite3_column_type() return

Re: [sqlite] ColType lost

2007-09-04 Thread drh
"Andre du Plessis" <[EMAIL PROTECTED]> wrote: > > I use the API as always: > > ColType := sqlite3_column_type(Pointer(FHandle), I); > > This has always worked fine for me and type returned was SQLITE_TEXT > If sqlite3_column_type() returns SQLITE_NULL when in fact the column really contains a

[sqlite] ColType lost

2007-09-04 Thread Andre du Plessis
Good Evening. SCHEMA: SOMECOLUMN TEXT I use the API as always: ColType := sqlite3_column_type(Pointer(FHandle), I); This has always worked fine for me and type returned was SQLITE_TEXT however lately I noticed that a particular table this is sometimes returned to me as