Adobe AIR/SQLlite ArrayCollection error

Posted on 2009-05-12
Last Modified: 2013-11-11
I am connecting to a SQLite database. I want to return the results as an array collection to display in a datagrid, but i am getting the following error:

Severity and Description      Path      Resource      Location      Creation Time      Id
Type was not found or was not a compile-time constant: data. [Generated code (use -keep to save): Path:, Line: 156, Column: 14]            hitAndRun      Unknown      1242153146345      3006

When i debug the application the results are returned correctly in an array but there is an error when my datagrid isnt commented out. thanks in advance.
<?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 var acPeeps:ArrayCollection;


			private function init():void


				sqlFile = File.applicationStorageDirectory.resolvePath("motility.db");

				sqlConn = new SQLConnection();, SQLMode.CREATE);


				var stmt:SQLStatement = new SQLStatement();

				stmt.sqlConnection = sqlConn;

				stmt.text = "CREATE TABLE IF NOT EXISTS motility(" + 


						"date DATE, " + 

						"LtoRmostinarowBB TEXT, " + 

						"RtoLmostinarowBB TEXT, " + 

						"LtoRhitsBB TEXT, " + 

						"RtoLhitsBB TEXT)";



				 var result:SQLResult = stmt.getResult();

				 trace("Table was created");



			private function createRecord():void


				var stmt:SQLStatement = new SQLStatement();

				stmt.sqlConnection = sqlConn;

				stmt.text = 

				"INSERT INTO motility(" + 

				"date, LtoRmostinarowBB, RtoLmostinarowBB, " + 

				"LtoRhitsBB, RtoLhitsBB) " + 

				"VALUES (" + 

				"'03-12-2009', '18', '4', '30', '33')";


				var result:SQLResult = stmt.getResult();

				trace("Data inserted");



			private function retrieveData():void



				var stmt:SQLStatement = new SQLStatement();

				stmt.sqlConnection = sqlConn;

				stmt.text = "SELECT * FROM motility";


				var result:SQLResult = stmt.getResult();


				acPeeps = new ArrayCollection(;









	<mx:Button x="284" y="158" label="Insert Data" click="createRecord()"/>

	<mx:Button x="284" y="158" label="Retreive Data" click="retrieveData()"/>

	<!--<mx:DataGrid dataProvider="{acPeeps}"/>-->



Open in new window

Question by:rarid122481
1 Comment

Accepted Solution

Fuzzy_Logic_ earned 500 total points
ID: 24373392
The only thing I can see wrong here is that the date value you are trying to insert is not of the correct format.

It should be: YYYY-MM-DD

try changing 03-12-2009 to 2009-12-03 (I'm assuming you mean 3rd December)

Regards FL

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Introduction This article is primarily concerned with ActionScript 3 and generally specific to AVM2.  Most suggestions would apply to ActionScript 2 as well, and I've noted those tips that differ between AS2 and AS3. With the advent of ActionS…
The last time I worked with Flash and Socket connections was in AS1. A recent project required flash connecting to a Socket, and sending receiving information - we figured it would be easy enough - we all know about the socket policy documents and c…
The goal of the tutorial is to teach the user how to use the auto adjust feature and what the different options do. When your video is not working right you can choose the auto adjust feature to help choose your settings.
The goal of the tutorial is to teach the user what frame rate is, how to control it and what effect it has on the video.

744 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

11 Experts available now in Live!

Get 1:1 Help Now