Adobe AIR/SQLlite ArrayCollection error

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: data-generated.as, 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="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;
			
			[Bindable]
			private var acPeeps:ArrayCollection;
			
			private function init():void
			{
				sqlFile = File.applicationStorageDirectory.resolvePath("motility.db");
				sqlConn = new SQLConnection();
				sqlConn.open(sqlFile, SQLMode.CREATE);
				
				var stmt:SQLStatement = new SQLStatement();
				stmt.sqlConnection = sqlConn;
				stmt.text = "CREATE TABLE IF NOT EXISTS motility(" + 
						"playerid INTEGER PRIMARY KEY AUTOINCREMENT, " + 
						"date DATE, " + 
						"LtoRmostinarowBB TEXT, " + 
						"RtoLmostinarowBB TEXT, " + 
						"LtoRhitsBB TEXT, " + 
						"RtoLhitsBB TEXT)";
 
				 stmt.execute();
				 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')";
 
				stmt.execute();
				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";
				stmt.execute();
				var result:SQLResult = stmt.getResult();
				
				acPeeps = new ArrayCollection(result.data);
				
			}
			
		]]>
	</mx:Script>
	
	
	
	<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}"/>-->
	
</mx:WindowedApplication>

Open in new window

rarid122481Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Fuzzy_Logic_Commented:
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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Adobe Flash

From novice to tech pro — start learning today.