Icontem

SQLite Connector Class: Access SQLite databases from AIR applications

Recommend this page to a friend!
  Info   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2010-09-16 (9 years ago) RSS 2.0 feedNot enough user ratingsTotal: 508 All time: 53 This week: 6Up
Version License JavaScript version Categories
sqlite-db-connector 1.0Custom (specified...1.0Databases, Adobe AIR
Description Author

This object can be used to access SQLite databases from AIR applications.

It can create new database files, connect to a given database file, prepare and execute SQL queries and retrieve the result set rows.

This object is part part of the Wind Rotor JavaScript library.

Name: Sergei Selihov <contact>
Classes: 1 package by
Country: Ukraine Ukraine
Age: 34
All time rank: 472 in Ukraine Ukraine
Week rank: 13 Up1 in Ukraine Ukraine Up

Details
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;
  }
  Files folder image Files  
File Role Description
Plain text file jlcSQLiteDBConnector Class QLite database connector class
Accessible without login Plain text file LICENSE Lic. License text file
Accessible without login Plain text file readme Doc. Readme file with example

 Version Control Unique User Downloads Download Rankings  
 0%
Total:508
This week:0
All time:53
This week:6Up