# Air and sqlite

**URL:** <https://forum.kirupa.com/t/air-and-sqlite/282647>\
**Category:** flash\
**Created:** [February 24, 2009, 5:46pm UTC](https://forum.kirupa.com/t/air-and-sqlite/282647 "2009-02-24T17:46:45Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![surf](https://avatars.discourse-cdn.com/v4/letter/s/77aa72/32.png) [@surf](https://forum.kirupa.com/u/surf)\
**Post date:** [February 24, 2009, 5:46pm UTC](https://forum.kirupa.com/t/air-and-sqlite/282647/1 "2009-02-24T17:46:45Z")

</div>

Hi…  
i have the following problem…

- i can

```auto

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…