Re: [Tutor] OT - SQL methodolgy

2005-03-22 Thread Liam Clarke
Hi Lloyd, it's a SQLite database, with only one app connecting, so I'm not worried about concurrency right here, ( I think SQLite locks when you connect anyway), but it's always good to get pointers on best practise. Thanks to all. On Tue, 22 Mar 2005 14:10:24 -0500, Lloyd Kvam <[EMAIL PROTECT

[Tutor] OT - SQL methodolgy

2005-03-22 Thread Lloyd Kvam
> > In the SQL books I've got, they always seem to have an optional select > > statement on the end of inserts/updates, and I was thinking maybe I > > could do it that way also, but I can't figure out a logical way of > > putting > > > > 'select primary_key from foo where primary_key value > every