New topic: Differences in using db.ommit
<http://forums.realsoftware.com/viewtopic.php?t=34250> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message Dipke Post subject: Differences in using db.ommitPosted: Sat Jun 12, 2010 3:27 am Joined: Fri Jun 27, 2008 3:42 am Posts: 113 Hello, Why there is a difference in using db.commit ? Scenario 1 I have properties in the app class that point to a realsqldatabase and a recordset (through a database class) Scenario 2 I create a Realsqldatabase and a recordset using the Dim statement in a Method When i delete a record with scenario 1 i have to use the db.commit after each delete When i delete a record with scenario 2 i can wait until i have deleted all the records and do the db.commit at the end. The rest of the code is equal to both scenarios. Can anyone help me ? Kind regards Top timhare Post subject: Re: Differences in using db.ommitPosted: Sat Jun 12, 2010 5:33 pm Joined: Fri Jan 06, 2006 3:21 pm Posts: 7886 Location: Portland, OR USA There should be no difference. There's something else going on. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 posts ] -- 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]
