New topic: Cannot Make REALSQLDatabase Multiuser
<http://forums.realsoftware.com/viewtopic.php?t=38806> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message ragnar Post subject: Cannot Make REALSQLDatabase MultiuserPosted: Wed Apr 27, 2011 10:48 pm Joined: Sun Dec 02, 2007 7:57 pm Posts: 5 I am using a REALSQLDatabase for data storage for my application and want a background thread running that also reads and writes that database. The main and background threads have their own instances independently connected and set to dbLocal.multiuser=true after connecting. However attempts to write to the database fails with a "database locked" error. Looking at the files, the two extra files the manual says should be there appear and disappear when the database is opened (and made multiuser) and closed. The documentation says nothing about this. Is there something I'm doing wrong or do I have to give up on this idea? Top ragnar Post subject: Re: Cannot Make REALSQLDatabase MultiuserPosted: Wed Apr 27, 2011 11:46 pm Joined: Sun Dec 02, 2007 7:57 pm Posts: 5 Found an answer so I'm answering my own question.... leaving it up in case someone else has the same problem. It works if dbInstance.ThreadYieldInterval is >0, i.e. not disabled. In my case I set it to 100. 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]
