New topic: Rollback and MySQL
<http://forums.realsoftware.com/viewtopic.php?t=44790> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message Hawkcode Post subject: Rollback and MySQLPosted: Fri Jul 20, 2012 4:32 pm Joined: Sat Jul 24, 2010 12:20 am Posts: 15 Hi, Using MySql Free version. I have several records to write out to different tables and if on fails I thought I could rollback everything. >From what I read there is an implicit Start transaction when data is changed >in the table. Here is what I'm doing. Its a typical Order entry apply payment. Create Order Record Create Line Items Records Get payment and Post. Got an error here and did Rollback. The records were saved anyway???? Any Ideas? Thanks Rich Top Bob Keeney Post subject: Re: Rollback and MySQLPosted: Fri Jul 20, 2012 4:38 pm Joined: Fri Sep 30, 2005 11:48 am Posts: 3127 Location: Lenexa, KS Do you do a Start Transaction, first? Otherwise Rollback does nothing. _________________ Bob K. 36+ hours of Real Studio Video Training at http://www.bkeeney.com/ Real Studio Consulting http://www.bkeeney.com/consulting/real-studio-consulting BKeeney Briefs Blog For Real Studio Developers http://www.bkeeneybriefs.com/ 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]
