FLASH-AIR No.1

import flash.data.SQLConnection;
import flash.events.SQLErrorEvent;
import flash.events.SQLEvent;
import flash.filesystem.File;
import flash.events.Event;

btnCreateDatabase.addEventListener(MouseEvent.CLICK, createDb);

function createDb(e:Event):void{
    var conn:SQLConnection = new SQLConnection();

    conn.addEventListener(SQLEvent.OPEN, openHandler);
    conn.addEventListener(SQLErrorEvent.ERROR, errorHandler);

    //applicationDirectory merupakan tempat aplikasi
    //air kita terinstall
    var folder:File = File.applicationDirectory;
    var dbFile:File = folder.resolvePath(namaDatabase.text);

    conn.openAsync(dbFile);
}


function openHandler(event:SQLEvent):void
{
    status.text = "Success :: Database berhasil dibuat ";
    status.text += "\n"+namaDatabase.text;
}

function errorHandler(event:SQLErrorEvent):void
{
    status.text = event.error.message;
    status.text += event.error.details;
}