Posts Tagged ‘database’

SQLite Example for Adobe AIR–Working with local SQL databases(with source code)

Windows-Table-256x256 Adobe AIR includes the capability of creating and working with local SQL databases. Many stand SQL features are supported in the runtime, open source SQLite system can be used for storing local, persistent data.

The flollowing is a simplistic example that create a sqlite database, add, get, update and remove records from the “user” table.

Notice:
You might have wondered about this line:

  1. sqlConnection.openAsync(dbFile);

.Asychnronous means that your code will have an event listener on the SQLConnection and an event handler for the response.

.Synchronous means that your application will make an “inline” call to SQLite where it performs the operation and then moves on as if it were any other line of actionscript code.This tutorial is using the asynchronous method. :)

(more…)

ActionScript MySQL Driver:asSQL,access database from Flex

As we all know,we can not use that datasource to connect to a database with flex,and Flex does not connect to DB directly.There is better data integration with FlexBuilder 3 but we also can not connect to a database directly and load/push data,it’s in the form of wizards to help developers write server code side to talk to databases.Then from Flex how does flex appication access data from a database?

(more…)