How to test 1st app (using sqlite and datagrid) on AVD

Got a LiveCode personal license? Are you a beginner, hobbyist or educator that's new to LiveCode? This forum is the place to go for help getting started. Welcome!

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller

shattuck49
Posts: 10
Joined: Fri Aug 23, 2013 2:57 am

Re: How to test 1st app (using sqlite and datagrid) on AVD

Post by shattuck49 » Tue Sep 03, 2013 2:54 am

Simon,

I have attached a copy of my SQLite database.

John
Attachments
SWLicense.zip
(6.61 KiB) Downloaded 156 times

Simon
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 3901
Joined: Sat Mar 24, 2007 2:54 am

Re: How to test 1st app (using sqlite and datagrid) on AVD

Post by Simon » Tue Sep 03, 2013 3:27 am

Hi John,
Using your sqlite file and the attached stack I was able to connect to the DB and display the results in the sim.
Note, I'm only using table Install
You will have to add Copy Files (again I think it's good to have it in your "Documents" folder)

Testing: Try the delete DB button while on the sim, it will say if it actually deleted something or it couldn't find the DB.

Simon
Attachments
Sqlite_Example (2).zip
LC 6.1
(6.52 KiB) Downloaded 145 times
I used to be a newbie but then I learned how to spell teh correctly and now I'm a noob!

shattuck49
Posts: 10
Joined: Fri Aug 23, 2013 2:57 am

Re: How to test 1st app (using sqlite and datagrid) on AVD

Post by shattuck49 » Thu Sep 05, 2013 2:43 am

Simon,

I am now able to read my SQLite database in the Android emulator. At first I couldn't make it work using your code as an example. But when I created a new stack, and used your code, it worked. That also fixed the problem where some of my controls were all black when displayed in the emulator.

Thank you for your help (and patience).

John

Simon
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 3901
Joined: Sat Mar 24, 2007 2:54 am

Re: How to test 1st app (using sqlite and datagrid) on AVD

Post by Simon » Thu Sep 05, 2013 3:04 am

Hi John,
Glad you got it working. :D
I'm not often crazy.

Simon
I used to be a newbie but then I learned how to spell teh correctly and now I'm a noob!

Post Reply