SQLite Connector Class: Access SQLite databases from AIR applications

Files:

LICENSE.txt - Open Software License ("OSL") v. 3.0 text
jlcSQLiteDBConnector.js - SQLite database connector class 

Example:

var CurDBConnector = new jlcSQLiteDBConnector();
var tmpDBFile = air.File.applicationStorageDirectory.resolvePath('database\\main1.db');
var tmpSQLQuery = '';
   
var Counter1 = 0;
    
try
  {
  CurDBConnector.CreateDBFile(tmpDBFile, true, 'update');
  }
catch (usrError)
  {
  return false;
  }    
    
try
  {  
  tmpSQLQuery =     
    
  "CREATE TABLE IF NOT EXISTS deluxe_coachwork_link (" +  
  "    id INTEGER PRIMARY KEY AUTOINCREMENT, " +  
  "    sportsmenwork INTEGER, " +  
  "    coachwork INTEGER " +  
  ")";

  CurDBConnector.SetQuery(tmpSQLQuery);
  CurDBConnector.ExecuteQuery(tmpSQLQuery);
  }

catch(usrError)
  {
  return false;
  }