Hi Mark,
There are a number of tools but I have found the Firefox extension SQLLite
Manager to be very useful.
You probably already have these but be sure to have attached error event
listeners:
conn = new SQLConnection();
conn.addEventListener(SQLErrorEvent.ERROR, errorHandler);
conn.addEventListener(SQLEvent.OPEN,
openHandler);
stmt = new SQLStatement();
stmt.sqlConnection = conn;
stmt.addEventListener(SQLEvent.RESULT,
stmt_resultHandler);
stmt.addEventListener(SQLErrorEvent.ERROR, errorHandler);
When utilising the mapped applicationStorageDirectory, the database will
typically be created on a PC within the users/appData/Roaming directory
(Windows) and the folder may have .debug appended.
-> for more information you can take a look at the nativePath property
File.applicationStorageDirectory.resolvePath("test.db").nativePath;
Hope this helps get you started.
Cheers
Darren
-----Original Message-----
From: Mark Fuqua [mailto:[email protected]]
Sent: 31 October 2013 14:18
To: [email protected]
Subject: sqlite, wits end
I am at my wits end, which as usual, seems much too short a trip.
I am trying to download records from a remote database and duplicate them in a
sqlite database. I have been using information from the book "Flex Mobile In
Action" (excellent reference BTW).
I have succeeded with one simple bit.taking log in info, comparing it to remote
info, returning userInfo and storing it in the local database. So I know the
database is created and is connected ect.
So now I am trying more complicated table..It is not working.spent the last few
days pulling my hair out. I can't seem to get any error messages to show
anywhere and Google seems to be pretty sparse in this area. So.
How do I debug sqlite problems?
Where is the database stored on my phone.can't find it anywhere.
Is there a way to see error messages? A sqlIte log of sorts?
When I run the app in the simulator, does it create a SQLite database on my
PC? Where would it be? Is there a SQLite database manager I can download for
looking at/testing queries against for the PC or Android?
Thanks,
Mark Fuqua
[email protected]
2301 Mount Carmel Road
Parkton, MD 21120
(410) 215-7356
www.availdata.com
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.3426 / Virus Database: 3222/6795 - Release Date: 10/30/13
