New topic: PRAGMA auto_vacuum (REALSQLdatabase)
<http://forums.realsoftware.com/viewtopic.php?t=31395> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message Shedrik Post subject: PRAGMA auto_vacuum (REALSQLdatabase)Posted: Thu Dec 03, 2009 3:06 am Joined: Tue Jan 29, 2008 12:24 pm Posts: 7 Hello, I'm trying to set the auto_vacuum mode to 1 ("full"). http://www.sqlite.org/pragma.html#pragma_auto_vacuum res = db.CreateDatabaseFile db.SQLExecute( "pragma auto_vacuum = 1" ) db.SQLExecute( "create table Users( .... )" ) But sqlSelect( "pragma auto_vacuum" ) always returns 0... And SQLiteManager shows that the auto_vacuum mode is OFF. Is it possible to set the auto_vacuum pragma with RB? ------------------- RB 2009 R4 on Mac OS X 10.6.2 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]
