Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Flex/Air and SQLite

Posted on 2009-05-14
3
Medium Priority
?
642 Views
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.
0
Comment
Question by:moglie
  • 2
3 Comments
 
LVL 5

Expert Comment

by:Fuzzy_Logic_
ID: 24392138
0
 
LVL 5

Accepted Solution

by:
Fuzzy_Logic_ earned 2000 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="http://www.adobe.com/2006/mxml" layout="vertical" creationComplete="init()">
        
        <mx:Script>
                <![CDATA[
                        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();
                                sqlConn.open(sqlFile, 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)";
 
                                 sql.execute();
                                 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 + "')";
 
                                sql.execute();
                                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;
                                sql.execute();
                                var result:SQLResult = sql.getResult();
                                
                                var empsAC:ArrayCollection = new ArrayCollection(result.data);
 
                                this.empID.text = empsAC[0].empID;
                                this.eName.text = empsAC[0].eName;
                                this.age.text = empsAC[0].age;
                                
                        }
                        
                ]]>
        </mx:Script>
        
        
        <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" />
        
        </mx:Tile>
</mx:WindowedApplication>

Open in new window

0
 

Author Comment

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

Featured Post

Automating Your MSP Business

The road to profitability.
Delivering superior services is key to ensuring customer satisfaction and the consequent long-term relationships that enable MSPs to lock in predictable, recurring revenue. What's the best way to deliver superior service? One word: automation.

Question has a verified solution.

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

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…
Aerodynamic noise is the cause of the majority of the noise produced by helicopters. The inordinate amount of noise helicopters produce is a major problem in the both a military and civilian setting. To remedy this problem the use of an aerogel coat…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

916 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