LiveCode Forums.

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....

Simon,

I have attached a copy of my SQLite database.

John

Simon,

How do I send you a copy of my database. "Upload attachment" rejected every name I tried for the database.

Simon, Finally tried your code with my SQLite database. Still does not work. Error message is that it cannot find the table in my Select statement (which works fine in the IDE). I am using the most recent version of SQLite. How can I find out which version is supported by LiveCode (which created the...

Simon,

Your example works fine in the Android emulator. I will go through the code and compare it to mine.

I will let you know what I find.

Thanks.

John

Simon, Yes, I ran the tutorial in the AVD with no problem. And I do have my SQLite database in the "documents" folder like the tutorial. But I still get no data in my datagrid when I test (even though it tests fine in the IDE). I noticed that the code in the tutorial is at the Card level while my co...

Still no success. I have tried your code and the tutorial you suggested and my datagrid will only fill when run within the IDE, not the AVD. I notice that the tutorial creates the SQLite database (there is no SQLite file in the "Copy Files" section) where mine copies my SQLite database. I cannot fin...

That did not make any difference (the datagrid was still empty). I pasted your code, changed the database name to mine, and made sure the database was not open. For some reason LiveCode cannot find, open, and read my database in Android although it works fine when tested in the IDE in Windows 7.

I have tried both "documents" and "engine" with no luck. I get feedback telling me that sqlite dabase is open (or is it creating a new one?) but when I try to load the data into the datagrid I get nothing. Can LiveCode handle an external sqlite database or does it have to be internal. The tutorials ...

I am writing my 1st app, which uses a sqlite database and a datagrid, and it works fine when tested in the IDE. However, when I test in the AVD, I just get an empty datagrid. Can anyone point me to a tutorial or example on how to test and use sqlite and a datagrid in Android. I've looked at the tuto...