Need Assistance

[steve_nam]

Hi fellow LiveCoders
Anybody willing to assist a newbie/non-coder with incorporating a sqlite database into my android mobile application using LiveCode. I have done the lesson at (http://lessons.runrev.com/s/3527/m/4069 ... e-database) but nothing is happening. I have also worked with the Elenor's SummerSchoolApp example, with the same result.....nothing.

I would really like somebody to take my database and my stack and point out to me my mistakes as well as telling me how it is supposed to be.

Thanking my hero on a white horse in advance.
Steve

[bangkok]

First... what does "nothing" mean ?


Alright, zip your stack + sql file, and post it here, so we can have a look.

[steve_nam]

Bangkok,
Thanks for offering to assist.

"Nothing" means that the screen/stack that is supposed to display the information from the database remains blank. Attached find the zip file with:
a) 2 photos for the blob in the table,
b) the livecode stack and
c) the sqlite database file

I want to thank you in advance.

Regards
Steve
Namibia (Africa)

[bangkok]

OK.

First problem, and a big one :

-you arrive on the card id 1056
-here you send the command databaseConnect
-but the script is defined on the card script of the card id 1061 !
-it can't work, because of the message path
-the script should be located in the stack script

Second problem :
-the script databaseConnect... calls another script that is not defined at all : setDatabaseID
But don't bother with it : just store the ID of the connexion (tDatabaseID) into a global var

Third problem :
-you have a function databaseGetContactDetails to read all the content of the database ("select * from")... that is not called, nowhere. You should call it from a button like "Display all records"

Fourth problem :
-but this function databaseGetContactDetails calls... another function that doesn't exist : getDatabaseID()

... My advice : you still have some work to do....

Don't bother with the interface first. Put everything onto one single card, it will be easier for you to understand how all the parts can, and shall, work together.

PS : i've fixed your stack for the connexion, and to display all the content of the table, by adding a button on the second card.
It works on Windows. SQLlite file must located into "My documents" directory.

[steve_nam]

Bangkok,
Thanks a million for your assistance. Greatly appreciated. I downloaded the zip but will only have time over the weekend to look at it and try to tackle some of the issues you raised. I know I still have a lot to do, but I will read, visits blogs, forums etc to see how far I will get.

Thanks again for assisting a non-coder, who desperately wants to learn Livecode as I believe it is the most user friendly and easy way to develop mobile apps.

Kind regards,
Steve