发行PRAGMA声明AIR应用程序 [英] Issuing PRAGMA statement in AIR app
问题描述
当我使用flash.data程序发出SQLite的杂编码的声明,我得到一个错误提示,这是不支持的:
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?
推荐答案
在一个字没有。有关支持和不支持的功能。
In a word no. See for supported and unsupported features.
<一个href="http://help.adobe.com/en_US/as3/dev/WSd47bd22bdd97276f1365b8c112629d7c47c-8000.html#WSd47bd22bdd97276f-5741a41a1262b2de46b-8000" rel="nofollow">http://help.adobe.com/en_US/as3/dev/WSd47bd22bdd97276f1365b8c112629d7c47c-8000.html#WSd47bd22bdd97276f-5741a41a1262b2de46b-8000.
不过该网页,但是你会看到... 系统表访问不可 该系统表,包括SQLITE_MASTER并与sqlite_preFIX其他表都没有在SQL语句中使用。运行时包括一个模式API,它提供一个面向对象的方式来访问模式数据。欲了解更多信息,请参阅<一href="http://help.adobe.com/en_US/FlashPlatform/reference/actionscript/3/flash/data/SQLConnection.html#loadSchema%28%29"相对=nofollow> SQLConnection.loadSchema()方法。
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.
有关使用loadSchema更详细的帮助看一下,
For a more detailed help in using loadSchema have a look at,
http://gmarius.posterous.com/a-test-33
和考虑使用,
http://sqlitebrowser.sourceforge.net/ 事实上
这篇关于发行PRAGMA声明AIR应用程序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!