mercredi 31 décembre 2014

Get a Value from One Cell in Sqlite to Livecode

I am using sqlite as my database. It is connected to the livecode project.


The Contacts table has the following data (address and contact number are omitted for security)



ID Name Address Contact No.
1 John ...Philippines 0999999999
2 Kim ...Philippines 0999999999


When I executed this command...



SELECT Name from Contacts ORDER BY ID DESC LIMIT 1


It will return



Kim


In Livecode, I want to store that value to the variable and display it as a Message Box.


How to do that?


Aucun commentaire:

Enregistrer un commentaire