New topic: SQLite Rollback Question
<http://forums.realsoftware.com/viewtopic.php?t=30713> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message TomHicks Post subject: SQLite Rollback QuestionPosted: Wed Oct 28, 2009 3:36 am Joined: Mon Aug 20, 2007 9:42 am Posts: 126 Let's say I have a multi-user database with two users, Anne and Bob, each using their own DB login. 1. Anne starts adding some records with, but doesn't COMMIT them. 2. Bob starts adding some records, but doesn't COMMIT them. 3. Anne and Bob continue adding records. 4. Anne issues a COMMIT command to actually add the data to the database. 5. Bob decides he doesn't want to save the records he added for some reason, and a ROLLBACK command is issued. Two questions: 1 - Does Bob's ROLLBACK revert the database to its state at point 2, or does it only undo his own additions? 2 - Whilst Anne and Bob are adding records which are unCOMMITted, can they see each others additions in the database via SELECTs? Thanks, Tom Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
