Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Flex/Air and SQLite

Posted on 2009-05-14
3
Medium Priority
?
625 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

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…
Are you an Exchange administrator employed with an organization? And, have you encountered a corrupt Exchange database due to which you are not able to open its EDB file. This article will explain all the steps to repair corrupt Exchange database.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

721 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