Re: [sqlite] Number of columns in table

Andreas Volz wrote: What is if the cell format is Number or BLOB? Does sqlite convert it always to char? Yes, the callback interface is a throwback to a time when all sqlite data was stored as strings. This interface only supports strings, so all fields are converted to strings to send to

Re: [sqlite] Number of columns in table

Am Wed, 30 Jan 2008 17:04:17 -0700 schrieb Dennis Cote: > > What if I like e.g. to write each table row into a file in one > > line? I need to know when a row is finished and the next begins. I > > could compare azColName, but I hope there is a better way. > > > > Andreas, > > Your

Re: [sqlite] Number of columns in table

Andreas Volz wrote: Hello, It's simple to the the maximum number of rows in a table with SELECT count(*) FROM table But how to find out the number of columns for a query like: SELECT * FROM table My practical problem is the read callback function: int readCallback (void *data, int argc,

[sqlite] Number of columns in table

Hello, It's simple to the the maximum number of rows in a table with SELECT count(*) FROM table But how to find out the number of columns for a query like: SELECT * FROM table My practical problem is the read callback function: int readCallback (void *data, int argc, char **argv,