Hi!!!!!!!!! I have tried to create a database and reteived data from it in SQLite for Adobe AIR application using Flex Builder3 .But I am unable to run the code.The code for this is as follows:
<?xml version="1.0" encoding="utf-8"?> <mx:WindowedApplication xmlns:mx="http://www.adobe.com/2006/mxml"; creationComplete="init()" layout="vertical"> <mx:Script> <![CDATA[ /* Import classes */ import flash.data.SQLConnection; import flash.filesystem.File; import flash.data.SQLResult; import flash.data.SQLStatement; import flash.events.SQLErrorEvent; import flash.events.SQLEvent; /* Declare properties */ private var dbConn:SQLConnection; private var dbFile:File; private static const CONNECT:Number = 0; private static const CREATE_TABLE:Number = 1; [Bindable] private var customers:Array; /** * @private * Load a local image that will be put into the embedded database */ private function init():void { dbFile = new File("app-storage:/Customers2.db"); if(!dbFile.exists) connect(CREATE_TABLE); else connect(CONNECT); } /** * @private * Create connection to embedded database and add listeners * @param type Number The type of connection necessary */ private function connect(type:Number):void { dbConn = new SQLConnection(); if (type) { dbConn.addEventListener(SQLEvent.OPEN, createTable); } else { dbConn.addEventListener(SQLEvent.OPEN, getCustomers); } dbConn.addEventListener(SQLErrorEvent.ERROR, errorHandler); dbConn.openAsync(dbFile); } /** * @private * Create the tables for the embedded database * @param eventObj SQLEvent */ private function createTable(eventObj:SQLEvent):void { var dbStatement:SQLStatement = new SQLStatement(); dbStatement.sqlConnection = dbConn; dbStatement.addEventListener(SQLEvent.RESULT, insertCustomer); dbStatement.addEventListener(SQLErrorEvent.ERROR, errorHandler); dbStatement.text = "CREATE TABLE customer (id INTEGER PRIMARY KEY, name TEXT, title TEXT)"; dbStatement.execute(); } /** * @private * Insert records into the embedded database * @param eventObj SQLEvent */ private function insertCustomer(eventObj:SQLEvent):void { var dbStatement:SQLStatement = new SQLStatement(); dbStatement.sqlConnection = dbConn; dbStatement.addEventListener(SQLEvent.RESULT, getCustomers); dbStatement.addEventListener(SQLErrorEvent.ERROR, errorHandler); dbStatement.text = "INSERT INTO customer (name, title) VALUES (’Adobe RSS’,’Agent’)"; dbStatement.execute(); } /** * @private * Get the customers list from the database * @param eventObj SQLEvent */ private function getCustomers(eventObj:SQLEvent):void { var dbStatement:SQLStatement = new SQLStatement(); dbStatement.sqlConnection = dbConn; dbStatement.addEventListener(SQLEvent.RESULT, customersResult); dbStatement.addEventListener(SQLErrorEvent.ERROR, errorHandler); dbStatement.text = "SELECT id, name, title FROM customer"; dbStatement.execute(); } /** * @private * Handle result from SQL query * @param eventObj SQLEvent */ private function customersResult(event:SQLEvent):void { customers = event.target.getResult().data; } /** * @private * Handle SQL error events * @param errorObj SQLErrorEvent */ private function errorHandler(errorObj:SQLErrorEvent):void { trace("Error ID: " + errorObj.errorID); trace("Message: " + errorObj.error.message); } ]]> </mx:Script> <mx:DataGrid dataProvider="{ customers }" width="100%" height="100%"> <mx:columns> <mx:DataGridColumn dataField="id" headerText="ID"/> <mx:DataGridColumn dataField="name" headerText="Name"/> <mx:DataGridColumn dataField="title" headerText="Job Title"/> </mx:columns> </mx:DataGrid> <mx:Button label="Add Record" click="insertCustomer(eventObj)" /> </mx:WindowedApplication> Kindly help me regarding this code......... -- View this message in context: http://www.nabble.com/Error--3115%3A-SQL-Error-tp24582876p24582876.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
