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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Scenario: Your operations manager has discovered an anomaly in your security system. The business will start to suffer within 15 minutes if it is a major IT incident. What should she do? We have 6 recommendations for managing major incidents (https:…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

895 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

14 Experts available now in Live!

Get 1:1 Help Now