New topic: database corruption
<http://forums.realsoftware.com/viewtopic.php?t=38044> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message dreamercon Post subject: database corruptionPosted: Thu Mar 10, 2011 3:55 pm Joined: Sun Nov 16, 2008 7:34 pm Posts: 58 I am new to using databases with real studio, and i have made a small desktop application that creates and accesses (locally) a simple realsql database. While everything seems to work fine, in several occasions, after playing with my application for a while, i would get a corrupt database file - essentially, opening the data file with a hex editor shows that all the information is gone and it just contains 3072 bytes of characters, the ones normally included in a blank database. Has anyone experience these kinds of issues? I save the database in the application support folder. I am also concerned about the potential impact to the database if my users open several instances of my application at the same time. How do you normally deal with this situation? (and how do you prevent users from doing so?) Also some of the varchar entries I have are very long (maybe 10K) and may include special characters - could that be an issue? Thanks for your help. 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]
