Re: [sqlite] Implementing LISTEN

2004-05-10 Thread D. Richard Hipp
Chris Waters wrote: [...] I need to know if: * A row was inserted. * A row was deleted. * A row was modified. I do this by creating three triggers on each table I want to monitor - one each of DELETE, INSERT, and UPDATE triggers. Each trigger writes information I need to know about the operation

[sqlite] sqlite exit codes

2004-05-10 Thread Andrew A. Raines
[I apologize if this comes through twice. I decided to re-send directly to the list because Gmane apparently isn't going to deliver my original.] I've been getting to know SQLite over the weekend. It's very cool. I need to share a database between a few processes -- one reader and a couple of

Re: [sqlite] sqlite exit codes

2004-05-10 Thread Derrell . Lipman
"Andrew A. Raines" <[EMAIL PROTECTED]> writes: > My solution, which seems to work well, is a poor man's blocking > scheme where access to the database loops until successful: > > while ! sqlite $DB_FILE "BEGIN TRANSACTION; $sql; COMMIT;" \ >>/dev/null 2>&1; do >

[sqlite] bla

2004-05-10 Thread Dau, Bernd
hey - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]