Air and sqlite

programming flash
1

Hi…
i have the following problem…

  • i can


public var conn : SQLConnection;
public var dbFile : File = new File(File.applicationDirectory.nativePath + "/db/dbName.sqlite");

private var queryTxt : String;
       
 public function DbMain () : void
        {
            conn = new SQLConnection();
            conn.addEventListener(SQLEvent.OPEN, onDbOpen);
            conn.addEventListener(SQLErrorEvent.ERROR, onDbError);
            conn.openAsync(dbFile);
        }

private function onDbOpen (e : SQLEvent) : void
        {
             selectAll();
        }

private function selectAll () : void
        {
            var queryText : String = "Select * from 'person'";
            onResultQuery(queryText);
        }

private function onQuery (queryTxt : String) : void
        {
            this.queryTxt = queryTxt ; 
            
            var results = query.getResult().data;   // This is where i am calling my results
            var query : SQLStatement ;
            query.sqlConnection = conn;
            query.text = queryTxt;
            query.addEventListener(SQLEvent.RESULT, onQueryRequest);
            query.addEventListener(SQLErrorEvent.ERROR, onQueryDError);
            query.execute() ;
                
            trace(query.text);
            trace(query.sqlConnection);
        }

private function onQueryDError (e : SQLErrorEvent) : void
        {
            trace("dbSQL query error");
        }

      
        private function onQueryRequest (e : SQLEvent) : void
        {
        }

ERRor
TypeError: Error #1009: Cannot access a property or method of a null object reference.

this error occurs every time i add the line
var results = query.getResult().data;

please help…