New topic: Autocommit
<http://forums.realsoftware.com/viewtopic.php?t=38361> Page 1 of 1 [ 3 posts ] Previous topic | Next topic Author Message MadDoc Post subject: AutocommitPosted: Mon Mar 28, 2011 11:17 am Joined: Wed Oct 05, 2005 1:21 pm Posts: 317 Location: United Kingdom I'm trying to get my head around foreign keys and SQLite. >From what I've read, in order to use foreign keys, you have to set AutoCommit >= True. I've done this after connecting to a database but nothing is ever >saved (unless I continue to call myDatabase.Commit). Is this normal >behaviour? I would have thought that setting AutoCommit = True means that you >shouldn't have to call the Commit method anymore?? MadDoc _________________ Figa Software | My Flickr | My Blog MacBook Pro 2.53Ghz, 4GB RAM, OSX 10.6.4, RB 2010r5.1 Pro Mac Mini 2.53Ghz, 4GB RAM, OSX 10.6.4 | iPhone 4 32GB | Nikon D60 Top Jym Post subject: Re: AutocommitPosted: Mon Mar 28, 2011 12:03 pm Joined: Sat Oct 01, 2005 5:19 pm Posts: 2330 You probably still have open transactions, wrap all your inserts and updates in SQLExecute"BEGIN' your transactions SQLExecute"END" Top MadDoc Post subject: Re: AutocommitPosted: Mon Mar 28, 2011 12:10 pm Joined: Wed Oct 05, 2005 1:21 pm Posts: 317 Location: United Kingdom Sweet - that worked. Thanks _________________ Figa Software | My Flickr | My Blog MacBook Pro 2.53Ghz, 4GB RAM, OSX 10.6.4, RB 2010r5.1 Pro Mac Mini 2.53Ghz, 4GB RAM, OSX 10.6.4 | iPhone 4 32GB | Nikon D60 Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 3 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]
