Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

Getting 'Error #3115: SQL Error.', details:'no such table:' Error when trying to execute SqlStatement

1

69 views

What I am trying to do is open a database in async mode and get some data from my database. To do I wrote this code down below:

var file:File = File.applicationStorageDirectory.resolvePath("data/mydatabase.db");
            sqlConnection = new SQLConnection();

            sqlConnection.addEventListener(SQLEvent.OPEN, openHandler);
            sqlConnection.addEventListener(SQLErrorEvent.ERROR, errorHandler);

            sqlConnection.openAsync(file,"read");

After, I wrote this code in openHandler method :

protected function openHandler(event:SQLEvent):void 
        { 
            Alert.show("Database has opened successfully");                 
            startstmt = new SQLStatement();             
            startstmt.sqlConnection = sqlConnection;
            startstmt.text = "SELECT tid FROM sectionstable WHERE farma LIKE '%heim%' OR indication LIKE '%heim%' LIMIT 0,10";              
            startstmt.execute();
        } 

My startstmt is a global SqlStatement variable. When I tested in Sqlite Manager it works fine this query but in adobe-air i am getting this error. Where did i do wrong and how can I solve this?

asked April 28, 2011 2:37 am CDT
posted via StackOverflow

1 Answers

0
 

It all looks right. You should check you table name.

answered April 29, 2011 11:19 pm CDT

Your answer

Join with account you already have


Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions