@ Darren, @lionel...both responses are helpful. I found the file on my PC, so that's a start. I have to take a two hour break now...but I'll be digging in when I return. Thank you both.
Mark -----Original Message----- From: Darren Woods [mailto:darren.wo...@altfusion.co.uk] Sent: Thursday, October 31, 2013 10:40 AM To: users@flex.apache.org Subject: RE: sqlite, wits end 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:m...@availdata.com] Sent: 31 October 2013 14:18 To: users@flex.apache.org 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 m...@availdata.com 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
