<?xml version="1.0" encoding="UTF-8"?><rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
		>
<channel>
	<title>Comments on: SQLite with AIR tutorial, conquer the DB.</title>
	<atom:link href="http://9mmedia.com/blog/?feed=rss2&#038;p=55" rel="self" type="application/rss+xml" />
	<link>http://9mmedia.com/blog/?p=55</link>
	<description>Flex / Actionscript  / Java</description>
	<lastBuildDate>Fri, 03 Sep 2010 15:41:02 +0000</lastBuildDate>
	<generator>http://wordpress.org/?v=2.9.2</generator>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
		<item>
		<title>By: Alex</title>
		<link>http://9mmedia.com/blog/?p=55&#038;cpage=1#comment-29382</link>
		<dc:creator>Alex</dc:creator>
		<pubDate>Mon, 29 Mar 2010 15:09:15 +0000</pubDate>
		<guid isPermaLink="false">http://9mmedia.com/blog/?p=55#comment-29382</guid>
		<description>I am attempting to use your tutorial but running into complications. I have created the database in SQLite, however, after saving the salesbuilder.db file and running the Flex application I receive an error &quot;Unable to open database file ...&quot;

Here is my database connection function:

private function initApp():void
		{
			// Open a connection to the local database. We keep that connection opened and 
			// use it through the course of this application. app-storage:/
			// Documents and Settings\Alex Dove\Desktop
			sqlConnection = new SQLConnection();
	        var file:File = new File(&quot;C:\Documents_and_Settings\Alex Dove\Desktop\salesbuilder.db&quot;);
	        sqlConnection.open(file);
			SQLConnectionManager.setConnection(&quot;salesbuilder&quot;, sqlConnection);

			// Create tables if they don&#039;t already exist
			var sqlUtil:SQLUtil = new SQLUtil();
			sqlUtil.executeBatch(File.applicationDirectory.resolvePath(&quot;data&quot; + File.separator + &quot;createtables.xml&quot;), sqlConnection);

			TabManager.tabNavigator = tn;
			TabManager.openDashboard();
		}

Do you see any issues? I have created a single &quot;Account&quot; in the SQLite database called &quot;Portillos&quot;. Its a groovy hot dog joint in Chicago. :)

Any help would be greatly appreciated.
Thank you.
Alex Dove</description>
		<content:encoded><![CDATA[<p>I am attempting to use your tutorial but running into complications. I have created the database in SQLite, however, after saving the salesbuilder.db file and running the Flex application I receive an error &#8220;Unable to open database file &#8230;&#8221;</p>
<p>Here is my database connection function:</p>
<p>private function initApp():void<br />
		{<br />
			// Open a connection to the local database. We keep that connection opened and<br />
			// use it through the course of this application. app-storage:/<br />
			// Documents and Settings\Alex Dove\Desktop<br />
			sqlConnection = new SQLConnection();<br />
	        var file:File = new File(&#8220;C:\Documents_and_Settings\Alex Dove\Desktop\salesbuilder.db&#8221;);<br />
	        sqlConnection.open(file);<br />
			SQLConnectionManager.setConnection(&#8220;salesbuilder&#8221;, sqlConnection);</p>
<p>			// Create tables if they don&#8217;t already exist<br />
			var sqlUtil:SQLUtil = new SQLUtil();<br />
			sqlUtil.executeBatch(File.applicationDirectory.resolvePath(&#8220;data&#8221; + File.separator + &#8220;createtables.xml&#8221;), sqlConnection);</p>
<p>			TabManager.tabNavigator = tn;<br />
			TabManager.openDashboard();<br />
		}</p>
<p>Do you see any issues? I have created a single &#8220;Account&#8221; in the SQLite database called &#8220;Portillos&#8221;. Its a groovy hot dog joint in Chicago. <img src='http://9mmedia.com/blog/wp-includes/images/smilies/icon_smile.gif' alt=':)' class='wp-smiley' /> </p>
<p>Any help would be greatly appreciated.<br />
Thank you.<br />
Alex Dove</p>
]]></content:encoded>
	</item>
	<item>
		<title>By: Wasserbetten</title>
		<link>http://9mmedia.com/blog/?p=55&#038;cpage=1#comment-14565</link>
		<dc:creator>Wasserbetten</dc:creator>
		<pubDate>Sat, 31 Oct 2009 12:29:45 +0000</pubDate>
		<guid isPermaLink="false">http://9mmedia.com/blog/?p=55#comment-14565</guid>
		<description>Thanks for sharing that tutorial and links!</description>
		<content:encoded><![CDATA[<p>Thanks for sharing that tutorial and links!</p>
]]></content:encoded>
	</item>
	<item>
		<title>By: Rich</title>
		<link>http://9mmedia.com/blog/?p=55&#038;cpage=1#comment-14512</link>
		<dc:creator>Rich</dc:creator>
		<pubDate>Tue, 27 Oct 2009 17:43:42 +0000</pubDate>
		<guid isPermaLink="false">http://9mmedia.com/blog/?p=55#comment-14512</guid>
		<description>Thanks for the tutorial. I&#039;m confused about how to actually access the data returned by getResult() - when I trace it or send it to a text box it&#039;s simply a list of objects. How do I get hold of the actual information returned (e.g. a string, for instance)?</description>
		<content:encoded><![CDATA[<p>Thanks for the tutorial. I&#8217;m confused about how to actually access the data returned by getResult() &#8211; when I trace it or send it to a text box it&#8217;s simply a list of objects. How do I get hold of the actual information returned (e.g. a string, for instance)?</p>
]]></content:encoded>
	</item>
	<item>
		<title>By: SQLite GUI tool &#171; Flex Flash ActionScript Developer</title>
		<link>http://9mmedia.com/blog/?p=55&#038;cpage=1#comment-14407</link>
		<dc:creator>SQLite GUI tool &#171; Flex Flash ActionScript Developer</dc:creator>
		<pubDate>Fri, 26 Jun 2009 03:56:54 +0000</pubDate>
		<guid isPermaLink="false">http://9mmedia.com/blog/?p=55#comment-14407</guid>
		<description>[...]  http://www.insideria.com/2008/03/air-api-introduction-to-the-sq.html http://9mmedia.com/blog/?p=55  [...]</description>
		<content:encoded><![CDATA[<p>[...]  <a href="http://www.insideria.com/2008/03/air-api-introduction-to-the-sq.html" rel="nofollow">http://www.insideria.com/2008/03/air-api-introduction-to-the-sq.html</a> <a href="http://9mmedia.com/blog/?p=55" rel="nofollow">http://9mmedia.com/blog/?p=55</a>  [...]</p>
]]></content:encoded>
	</item>
	<item>
		<title>By: lauren</title>
		<link>http://9mmedia.com/blog/?p=55&#038;cpage=1#comment-11763</link>
		<dc:creator>lauren</dc:creator>
		<pubDate>Mon, 02 Mar 2009 15:11:48 +0000</pubDate>
		<guid isPermaLink="false">http://9mmedia.com/blog/?p=55#comment-11763</guid>
		<description>hi dieyana,
you can check out the full code at the link given above:
http://svn.9mmedia.com/public/AirSQLite_itemlist

you&#039;ll need the subclipse plugin for eclipse or flex builder to access the svn, a quick google search will turn up plenty of instructions on how to do that.</description>
		<content:encoded><![CDATA[<p>hi dieyana,<br />
you can check out the full code at the link given above:<br />
<a href="http://svn.9mmedia.com/public/AirSQLite_itemlist" rel="nofollow">http://svn.9mmedia.com/public/AirSQLite_itemlist</a></p>
<p>you&#8217;ll need the subclipse plugin for eclipse or flex builder to access the svn, a quick google search will turn up plenty of instructions on how to do that.</p>
]]></content:encoded>
	</item>
</channel>
</rss>
