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    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 515 All time: 56 This week: 7Up
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.

Picture of Sergei Selihov
Name: Sergei Selihov <contact>
Classes: 1 package by
Country: Ukraine Ukraine
Age: 37
All time rank: 482 in Ukraine Ukraine
Week rank: 6 Up1 in Ukraine Ukraine Up

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  
This week:0
All time:56
This week:7Up