Re: [sqlite] sqlite3_free()

Thanks you for your help! Jason Alburger HID/NAS/LAN Engineer L3/ATO-E En Route Peripheral Systems Support 609-485-7225 [EMAIL PROTECTED]

[sqlite] sqlite3_free()

A few quick questions... If an error is returned by sqlite3_exec( ) , I believe the error message is written in the (char **errmsg) provided in the 5 parameter of the function call. 1. Is this the same error text that can be obtained by sqlite3_errmsg( ) ? 2. If this is the same

Re: [sqlite] Re: sqlite3_column_int( ) question

Thanks for your quick response. That did the trick. Jason Alburger HID/NAS/LAN Engineer L3/ATO-E En Route Peripheral Systems Support 609-485-7225 "Igor Tandetnik"

[sqlite] sqlite3_column_int( ) question

It looks to me that 'sqlite3_column_int( )' returns a '0' if the item is NULL in the table. Is there any way to get sqlite to tell you that the numerical item being queried is NULL instead of just returning a zero? Jason Alburger HID/NAS/LAN Engineer L3/ATO-E En Route Peripheral Systems

Re: [sqlite] performance statistics

wellThe database and the applications accessing the database are all located on the same machine, so distribution across multiple machines doesn't apply here. The system is designed so that only one application handles all the writes to the DB. Another application handles all the

[sqlite] performance statistics

All - I am currently investigating porting my project from postgres to SQLite due to anticipated performance issues (we will have to start handling lots more data). My initial speed testing of handling the expanded amount data has suggested that the postgres performance will be unacceptable.