Re: [sqlite] Size of IO operations

On Fri, Aug 9, 2013 at 1:55 PM, Andrew Beal wrote: > Hi All, > > Is there a way within SQLite to configure how many bytes each interaction > with the IO layer occur as? According to the > http://www.sqlite.org/atomiccommit.html doc, SQLITE does sector writes > and that is

[sqlite] Size of IO operations

Hi All, Is there a way within SQLite to configure how many bytes each interaction with the IO layer occur as? According to the http://www.sqlite.org/atomiccommit.html doc, SQLITE does sector writes and that is configured by the xSectorSize function within the IO Methods object. From the

Re: [sqlite] Where Clause

You need to evaluate the parameters of the given callback function. sqlite3_exec( db, , my_callback, , ); my_callback( void * param, int cols, char **values, char **names ) { Int *count = param; if (cols) { *count = atoi (values[0]); } }

Re: [sqlite] Default Constraint Behaviour!!!

On 08/09/2013 04:39 PM, techi eth wrote: Is it possible to read default value of any Colum? Ex : Create table by adding default constraint to Colum & then read back the default constraint value before doing INSERT,UPDATE. "PRAGMA table_info" provides access to this information:

[sqlite] Default Constraint Behaviour!!!

Is it possible to read default value of any Colum? Ex : Create table by adding default constraint to Colum & then read back the default constraint value before doing INSERT,UPDATE. Cheers - Techi ___ sqlite-users mailing list sqlite-users@sqlite.org