I don't want to send any of the developers on a wild goose chase, the problem might be somewhere else, since you suggested sqlite3_column_decltype() im thinking that it might be somewhere else in determining the column type initially I use sqlite3_column_type so the SQLITE_NULL may actually 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 also try and create a sample database that illustrates the problem? Creating a new ticket at: http://www.sqlite.org/cvstrac/tktnew does not allow me to attach any file, I wonder if I do a .dump and then import it would probably fix the problem as it would reinsert from text, so don't really want to provide sql inserts I should attach the database in binary form Or should I just send a mail to this group with a file attached? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 04 September 2007 08:11 PM To: sqlite-users@sqlite.org Subject: Re: [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() returns SQLITE_NULL when in fact the column really contains a text value and not a NULL, then that is a bug. You should report it. Please note, however, that sqlite3_column_type() returns the actual datatype of the content of a particular row of a particular column. It does *not* report on the declared datatype of a column. If you really asking for the declared datatype of a column, use sqlite3_column_decltype() instead. -- D. Richard Hipp <[EMAIL PROTECTED]> ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
