Flex/Air and SQLite

Posted on 2009-05-14
Last Modified: 2012-05-07
Could someone show me a very simple example of using Flex/Air with something other than a datagrid?  I'm trying to get a handle on using sqlite and i'd like to have something like a form or a few textinput components that you can input text into, save that data (to sqlite) and then when you reopen the app later, the data is there.
Question by:moglie
  • 2

Expert Comment

ID: 24392138

Accepted Solution

Fuzzy_Logic_ earned 500 total points
ID: 24392153
And a crude example I've knocked up stripped down to the bare basics for creating, inserting and selecting:

<?xml version="1.0" encoding="utf-8"?>

<mx:WindowedApplication xmlns:mx="" layout="vertical" creationComplete="init()">




                        import mx.collections.ArrayCollection;


                        private var sqlConn:SQLConnection;

                        private var sqlFile:File;


                        private function init():void


                                sqlFile = File.applicationStorageDirectory.resolvePath("emps.db");

                                sqlConn = new SQLConnection();

                      , SQLMode.CREATE);


                                var sql:SQLStatement = new SQLStatement();

                                sql.sqlConnection = sqlConn;

                                sql.text = "CREATE TABLE IF NOT EXISTS emps(" + 

                                                "empID INTEGER PRIMARY KEY AUTOINCREMENT, " + 

                                                "eName TEXT, " + 

                                                "age TEXT)";



                                 var result:SQLResult = sql.getResult();

                                 trace("emp table created");



                        private function saveEmp():void


                                var sql:SQLStatement = new SQLStatement();

                                sql.sqlConnection = sqlConn;

                                sql.text = 

                                "INSERT INTO emps (" + 

                                "eName, age )" + 

                                "VALUES ('" + 

                                this.eName.text + "', '" + this.age.text + "')";



                                var result:SQLResult = sql.getResult();

                                trace("emp saved");



                        private function getEmp():void



                                var sql:SQLStatement = new SQLStatement();

                                sql.sqlConnection = sqlConn;

                                sql.text = "SELECT * FROM emps WHERE empID = " + this.numID.value;


                                var result:SQLResult = sql.getResult();


                                var empsAC:ArrayCollection = new ArrayCollection(;

                                this.empID.text = empsAC[0].empID;

                                this.eName.text = empsAC[0].eName;

                                this.age.text = empsAC[0].age;








        <mx:Tile width="120">



        <mx:Button label="Save" click="saveEmp()"/>

        <mx:Button label="Get Employee" click="getEmp()"/> <mx:NumericStepper id = "numID" />

        <mx:Label text = "empID" />

        <mx:TextArea id="empID" width = "50" height = "20" editable="false"/>

        <mx:Label text = "eName" />

        <mx:TextArea id="eName" width = "100" height = "20" />

        <mx:Label text = "age" />

        <mx:TextArea id = "age" width = "50" height = "20" />




Open in new window


Author Comment

ID: 24396264
Thanks, that's what I needed to get me going in the right direction.

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

First things first - Preparation We need all the part for this install and it's much nicer to have them all on hand when you need them so here's what's required. Download Eclipse 3.5 32 bit (I like the Classic flavour) from here. (http://www.e…
This article will show you how to create an ISO CD-ROM/DVD-ROM image (*.iso), and MD5 checksum signature, for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5). It's a good idea to compare checksums, because many installations fail because of a corr…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now