New topic: RB 2009 r5 -- REALSQLdatabase Vacuum command
<http://forums.realsoftware.com/viewtopic.php?t=31370> Page 1 of 1 [ 3 posts ] Previous topic | Next topic Author Message Shedrik Post subject: RB 2009 r5 -- REALSQLdatabase Vacuum commandPosted: Wed Dec 02, 2009 7:50 am Joined: Tue Jan 29, 2008 12:24 pm Posts: 6 Hello, I have a question about Vacuum command (REALSQLdatabase). after the command: db.SQLExecute( "vacuum" ) database shows the next error message: "cannot VACUUM from within a transaction" But there are no active transactions. And code works fine with RB2009R4. Where could be the problem? ------------------- RB 2009 R5 on Mac OS X 10.6.2 Top simonjohn Post subject: Re: RB 2009 r5 -- REALSQLdatabase Vacuum commandPosted: Wed Dec 02, 2009 9:09 am Joined: Sat Apr 19, 2008 12:44 pm Posts: 286 Location: Dorset, UK This could be very bad! Please see my post 'Serious Bug in RB 2009 R5 - Transactions?' _________________ Simon Larkin QiSQL Database Solutions Website : http://www.qisql.com Mac 10.5.8, Imac 2.4ghz, 4gb, RB 2009 R4 Top Shedrik Post subject: Re: RB 2009 r5 -- REALSQLdatabase Vacuum commandPosted: Wed Dec 02, 2009 3:16 pm Joined: Tue Jan 29, 2008 12:24 pm Posts: 6 And it's not just an incorrect error message. My db file size is 2.3 MB. After the vacuum command it should be ~20 KB (all rows was deleted). But it still 2.3MB. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 3 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]
