Re: [sqlite] A way to get SQLite type from decl type?

This is the internal code that sqlite uses to convert the declaration type to the REAL, INT, TEXT, BLOB types. Happy hacking... /* ** Each token coming out of the lexer is an instance of ** this structure. Tokens are also used as part of an expression. ** ** Note if Token.z==0 then Token.dyn

[sqlite] A way to get SQLite type from decl type?

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.