Search code examples
sqliteencodingairpragma

Issuing PRAGMA statement in AIR app

When I use the flash.data routines to issue a SQLite "PRAGMA encoding" statement, I get an error suggesting that this isn't supported:

'Error #3115: SQL Error.', details:'PRAGMA is not allowed in SQL.', operation:'execute', detailID:'2005

Is there a workaround?

Solution

  • In a word no. See for supported and unsupported features.

    http://help.adobe.com/en_US/as3/dev/WSd47bd22bdd97276f1365b8c112629d7c47c-8000.html#WSd47bd22bdd97276f-5741a41a1262b2de46b-8000.

    However on that page however you will see... System table access is not available The system tables including sqlite_master and other tables with the "sqlite_" prefix are not available in SQL statements. The runtime includes a schema API that provides an object-oriented way to access schema data. For more information see the SQLConnection.loadSchema() method.

    For a more detailed help in using loadSchema have a look at,

    http://gmarius.posterous.com/a-test-33

    and consider using,

    http://sqlitebrowser.sourceforge.net/ In fact

    enter image description here