在AIR应用程序中发布PRAGMA语句 [英] Issuing PRAGMA statement in AIR app
问题描述
当我使用flash.data例程发出一个SQLitePRAGMA编码语句时,我收到一个错误提示不支持:
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
是否有解决方法?
推荐答案
字号查看支持和不支持的功能。
In a word no. See for supported and unsupported features.
然而,在该页面上,您将看到...
系统表访问不可用
包含sqlite_master和其他具有sqlite_前缀的表的系统表不是可用于SQL语句。运行时包括一个模式API,提供面向对象的方式来访问模式数据。有关更多信息,请参阅 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/ 其实
这篇关于在AIR应用程序中发布PRAGMA语句的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!