[sqlite] how to force a database to be corrupted

Hi, I was wondering, is there is way to force a database to be corrupted ? (obviously I need this for testing purposes). Basically I'd like to patch the database so the next sql command will return SQLITE_CORRUPT. Thanks, Olivier Singla Integrian, Inc. Raleigh, NC

[sqlite] sqlite with FORTRAN

Hi I am trying to figure out a wrapper to access sqlite from FORTRAN (g77 and gcc) I try using "cfrotran.h" but it seems I have problems passing arguments. Not sure I get the sqlite3 handle correctly Has anybody tried that before? Thanks Cornel

Re: [sqlite] Mozilla + SQLite?

Thanks for sharing! I'm looking forward to the calendar program.

Re: [sqlite] INTEGER data type

> That's correct for version 2.8. Version 3.0 expands the INTEGER PRIMARY > KEY out to 64 bits so you have a range of -18446744073709551616 to > +18446744073709551615. Seems unlikely to overflow... > -- > D. Richard Hipp <[EMAIL PROTECTED]> Thanks for the correction. Definately plenty of space

Re: [sqlite] Error 21, "library routine called out of sequence"

Derrell, Thanks for the idea and the excellent coding example. This works perfectly, thank! Regards, Ben. [EMAIL PROTECTED] wrote: Ben Clewett <[EMAIL PROTECTED]> writes: Dear SQLite, I am running a sequence of inserts: BEGIN INSERT INTO table ... INSERT INTO table ... INSERT INTO tabl

Re: [sqlite] Error 21, "library routine called out of sequence"

Ben Clewett <[EMAIL PROTECTED]> writes: > Dear SQLite, > > I am running a sequence of inserts: > > BEGIN > INSERT INTO table ... > INSERT INTO table ... > INSERT INTO table ... > INSERT INTO table ... > INSERT INTO table ... > > I am catching the 'kill -1' signal (aka CTRL-C) and executing a final

[sqlite] Error 21, "library routine called out of sequence"

Dear SQLite, I am running a sequence of inserts: BEGIN INSERT INTO table ... INSERT INTO table ... INSERT INTO table ... INSERT INTO table ... INSERT INTO table ... I am catching the 'kill -1' signal (aka CTRL-C) and executing a final query: COMMIT When I execute the 'COMMIT' I get: "library