Re: [sqlite] Performing multiple actions on a query

> > I know I can run the query again with a DELETE command, but what if > > the data has changed in between queries? > > Surround both statements with a BEGIN/COMMIT pair. Ahh, okay. That seems to do the trick. Thank you very much, Drake. ___ sqlite-use

Re: [sqlite] Performing multiple actions on a query

Quoth Ian Petts , on 2010-11-23 19:20:05 +1100: > I know I can run the query again with a DELETE command, but what if > the data has changed in between queries? Not a problem if you do both of them in the same transaction, AFAIK. Surround both statements with a BEGIN/COMMIT pair. If the condition

[sqlite] Performing multiple actions on a query

I'm trying to move data between two databases. I found in the list archive the following solution from Chris Wedgwood: ATTACH DATABASE 'fromdb.sqlite' AS fromdb; [...] INSERT INTO fromdb.tablename SELECT * FROM src; This appears to *copy* data between databases, but I would like to then delete th