Hi all, Is there a way to obtain the SQLite type (e.g. SQLITE_INTEGER) given the declared type from the schema?
What I'm really trying to do: I'm working on RSQLite, an interface for the R language to SQLite. I want to determine the type of the columns in an arbitrary result set. Everything is fine, except when the row used to do the checking has a NULL. In this case, I'd like to attempt to determine the type for the column if it isn't NULL. This may not make sense to you, but the return value I'm building is column oriented and R has special null-like values that are type-specific. If sqlite3_column_type returns SQLITE_NULL, I can use sqlite3_column_decltype to obtain the declared type. But then I still need to map that to SQLITE_INTEGER, SQLITE_REAL, or SQLITE_TEXT. Clearly the engine knows how to do this, but I couldn't find the API function (might just be blind ;-) Thanks much, + seth ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
