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 "INTEGER":
sqlite3_column_decltype("select amount from myvirtualtable", 0) returns
"INTEGER" -> good!
BUT:
sqlite3_column_decltype("select sum(amount) from myvirtualtable", 0) returns
NULL -> very bad!
Is there a possibility to get the declared datatype of an aggregate
function?
Because the function sqlite3_column_type() always returns SQLITE_NULL for my
virtual tables...
Thanks for every help!
Paul
--
View this message in context:
http://www.nabble.com/Get-declared-Datatype-of-SQLite-Virtual-Table-tp19330789p19330789.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users