New topic: MySQL recordset returns nil in thread conflicts in RB2010r2
<http://forums.realsoftware.com/viewtopic.php?t=33752> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message [email protected] Post subject: MySQL recordset returns nil in thread conflicts in RB2010r2Posted: Wed May 12, 2010 6:31 am Joined: Wed Jan 21, 2009 6:06 pm Posts: 4 For the first time RB2010r2 now allows RB threads to run at the same time as MySQL SQLSelect commands. This is great, but it has also introduced a problem. If one SQLSelect is running when a thread opens up another SQLSelect command the recordset from one clobbers the recordset of the other leading to recordset = nil results. i.e.. if I perform one SELECT command while an entirely different SELECT command is running in the background, the later SELECT command returns nil every time. If the background threads are not performing an SQLSelect (i.e. doing something else instead) or are run one after the other it works fine. I am not calling the same RB subroutine, but it is the same MySQL database. Does anyone know a workaround? 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]
