On 2/8/07, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
On 2/7/07, DragonK <[EMAIL PROTECTED]> wrote: > > > This seems to work... but I'm not sure if it should, that's why I'm > asking. > I hope the code will show more exactly what I intend to do. Sorry for the > lack of proper error checking, it's just a test program. :) Also, I'm not > using any transactions, just the PRAGMA synchronous= off; If it works that's great. I would double check that it did work correctly. I'll have to poke around now and see why what I did, which was pretty similar, didn't work.
Please inform me if you find anything wrong with this scenario, because I want to use something similar in production code. Also, I'd appreciate any other opinions if some of you tried something similar and had good/bad results. I don't know the internals of SQLite or of databases in general, but in this case i think the database knows the next row to be selected and deleting the currently selected row would not interfere with the select operation.... i think :) Thanks! --
The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com
-- ...it's only a matter of time...