Tutorial
Work with Local SQL database using AIR
Adobe integrated runtime (AIR) allows developers to built rich Internet applications. Here is a demo of using AIR's integrated SQL database engine
Sandeep Koul
Wednesday, February 11, 2009
Last part shows the version of AIR used:
Next line shows attribute to uniquely identify application:
sandeep.com
One can also define version of the application as :
version 1.0
sample
AIR Example
To define properties of the application window:
pcquest.html
false
true
true
true
true
640
480
150
150
 |
|
Before packaging, one can test the result of application using ADL. Simply move to application folder and type 'adl pcquest.xml' in command prompt.
|
To check the results of the created application, open command prompt and move to the application folder and type in the window:
Adl pcquest.xml
Finally one can easily package AIR application in just two steps, start with creating certificate and key pair for application as shown here:
adt -certificate -cn SelfSigned 1024-RSA testCert.pfx password
To create .air installer file, simply run following command, it will prompt for password :
adt -package -storetype pkcs12 -keystore testCert.pfx PCQUest.air pcquest.xml pcquest.html
Now one can distribute this application using PCQUest.air file. This shows how web developers having SQL knowledge can use their SQL skills in easily developing applications in AIR.
Now we have created the required descriptive file. Let's create a HTML page that contains code to create database and then display that database. Here is the code snippet showing the content of 'pcquest.html':