問題描述

我正在嘗試解決為什么我的代碼對所有查詢都返回 null 的原因，最后發現 sql 查詢什么都不返回.我用簡約的代碼創建了一個新的 AIR 文檔 (s:WindowedApplication):

I am trying to troubleshoot why my code returned null for all my queries and finally found that sql query returns nothing. I created a new AIR document (s:WindowedApplication) with minimalistic code:

<fx:Script>
        <![CDATA[
            import mx.events.FlexEvent;

            private var sqlConnection:SQLConnection;
            private var select:SQLStatement;
            private var databaseFile:File;

            protected function windowedapplication1_creationCompleteHandler(event:FlexEvent):void
            {
                var dbPath:String = "Movie Manager Settings/moovioDB2.db";
                databaseFile = File.userDirectory.resolvePath(dbPath);
                sqlConnection = new SQLConnection();
                select = new SQLStatement();

                sqlConnection.addEventListener(SQLEvent.OPEN, onDatabaseOpen);
                sqlConnection.openAsync();
            }

            private function onDatabaseOpen(event:SQLEvent):void
            {
                select.sqlConnection = sqlConnection;
                var query:String = "SELECT title FROM movies";
                select.text = query;
                select.addEventListener(SQLEvent.RESULT, done);
                select.execute();
            }

            private function done(event:SQLEvent):void{
                var res:SQLResult = select.getResult();
            }

        ]]>
    </fx:Script>

除此代碼外，只有 Flex 創建的標準標簽.執行后，我收到此錯誤:

Other than this code theres is just the standard tags created by Flex. Upon execution I get this error:

Error #2044: Unhandled SQLErrorEvent:. errorID=3115, operation=execute , message=Error #3115: SQL Error. , details=no such table: 'movies'

我已經用 2 個不同的 sqlite 程序檢查了數據庫文件并成功執行了查詢.電影"表和標題"列都存在.如果重要，電影是 3 個表之一，并且有超過 10 個列都存在值.

I have checked the database file with 2 different sqlite programs and executed the query successfully. Both 'movies' table and 'title' column exists. In case it matters movies is one of 3 tables and has over 10 columns all with values present.

我做錯了什么?我之前使用了相同的代碼(我認為)并獲得了預期的結果，但現在經過一些更改后，我什至可以在新文檔中使用此基本代碼.請檢查一下，看看我是否犯了一個愚蠢的錯誤，因為我看不到它:)

What am I doing wrong? I used identical code(I thought) before with expected results, but after some changes now I can even get this basic code in a new document to work. Please check it out and see if I am making a stupid mistake because I can't see it :)

推薦答案

你能驗證你打開的數據庫的路徑是你用外部工具檢查過的那個文件嗎?您可以在 AS3 代碼中使用 database_list pragma.就像執行任何其他 SQL 語句一樣執行它:

Can you verify that the path of the database you open is the one of that file you checked with external tools? You can use the database_list pragma from within you AS3 code. Just execute it as any other SQL statement:

[user@host ~]$ cd /tmp
[user@host tmp]$ sqlite3 foo.db
SQLite version 3.7.11 2012-03-20 11:35:50
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> pragma database_list;
0|main|/tmp/foo.db

這篇關于SQL 錯誤:“沒有這樣的表"的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！