I'm looking to truncate my database. According to SQLite documentation, issuing a "DELETE FROM databaseName" should run a fast truncate. This does not seem to work within AIR from my tests. It (the documentation) also states that"The truncate optimization can be permanently disabled for all queries by recompiling SQLite with the SQLITE_OMIT_TRUNCATE_OPTIMIZATION compile-time switch".
Was this the decision here? Will I need to copy my table, drop the table, rename the copy, and then run my SQLStatements to do a simple truncate?
Nevermind, it appears to simply be an error/issue from within Lita, an AIR application that was developed to manage SQLite databases. It works fine when run directly from my application.