Tito Ciuro wrote:
Hello,

After reading quite a bit about 'show_datatypes' I still don't get its workings.

After setting 'PRAGMA show_datatypes = ON;' I go ahead and perform a 'SELECT * FROM address_table LIMIT 1;' The resulting set contains 4 columns, 1 row:

[0] --> ROWID
[1] --> First
[2] --> Last
[3] --> Country
[4] --> 1
[5] --> Tito
[6] --> Ciuro
[7] --> Spain

Are you seeing these results with the callback or with sqlite_get_table. I'm betting sqlite_get_table, because the callback doesn't return results in that fashion. Anyway, you can't get the types with sqlite_get_table. Only with the callback. You can write your own sqlite_get_table to package up all the types for you. Or you can use the callback, in which case the types are returned appened to the end of the 4th argument.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to