Re: [sqlite] Get declared Datatype of SQLite Virtual Table

Igor Tandetnik wrote: > > "paul schindler" <[EMAIL PROTECTED]> > wrote in message news:[EMAIL PROTECTED] >> sqlite3_column_decltype("select amount from myvirtualtable", 0) >> returns "INTEGER" -> good! >> >> BUT: &

Re: [sqlite] Get declared Datatype of SQLite Virtual Table

D. Richard Hipp wrote: > > > On Sep 5, 2008, at 9:03 AM, paul schindler wrote: > >> >> Hello, >> >> I have a virtual table and some (by me) declared datatypes are >> "TEXT10" or >> "INTEGER" or "DATE"... >

[sqlite] Get declared Datatype of SQLite Virtual Table

Hello, I have a virtual table and some (by me) declared datatypes are "TEXT10" or "INTEGER" or "DATE"... When I am using the function sqlite3_column_decltype() then I get those types back, that's great. But I have a problem with aggregate functions. E.g. the field "amount" with the datatype "IN