New topic: MySQL InnoDB switch causes recordset to not update
<http://forums.realsoftware.com/viewtopic.php?t=31466> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message tfantz Post subject: MySQL InnoDB switch causes recordset to not updatePosted: Mon Dec 07, 2009 11:54 pm Joined: Wed Mar 22, 2006 4:47 pm Posts: 32 Location: Atlanta, GA I have a database with clients that has run fine on MYISAM tables for a long time. I want to move to a transaction model so I changed the table types to InnoDB. Now, when I update table data, I don't get errors, and a third party client (Sequel Pro) sees the changes, but if I query against the record by another RB client (not the one doing the update) I get the pre update fields. If I change the table back to MYISAM I get the updated info. I am trying to isolate this in a small project, but I am scratching my head. I am doing begins and commits and checking for errors and since I can retrieve the data on the client making the updates, the updates are not failing... it is like there is some kind of cache on the other clients side that isn't really fetching the new info. RB2009r4, MacOSX 10.6.2 MySQL Community Server 5.1.41 Regards, Todd Fantz 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]
