在AIR应用程序中发布PRAGMA语句

本文介绍了在AIR应用程序中发布PRAGMA语句的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

当我使用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.

help.adobe/en_US/as3/dev/WSd47bd22bdd97276f1365b8c112629d7c47c-8000.html#WSd47bd22bdd97276f-5741a41a1262b2de46b-8000 。

然而，在该页面上，您将看到... 系统表访问不可用包含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,

gmarius.posterous/a-test-33

并考虑使用

http：/ /sqlitebrowser.sourceforge/ 其实