LiveCode Forums.

I was wanting to have database connection and disconnection code in a stack (or card) and be able to call it from any card. I've found a number of options but none seem to work.

Example:

on dbConnect
insertcode here
end dbConnect

to call it I have tried

call dbConnect from card "cardname"

I ...

put "properties" into tTableName -- set this to the name of a table in your database
put "SELECT * FROM " & tTableName into tSQL

-- query the database
put revDataFromQuery(tab, cr, gConnectionID, tSQL) into tData

set itemdel to TAB
put tData

put item 2 of tData into fld "fldStreetNumber ...

Yes, as I said, the only difference in the code was the delimiter in the line put revdatafromquery(,,sDbId,tSql) into tData was set in my code.

There are no commas in my data. I put a simple test set of data. Has anyone actually used MySQL with LiveCode? And what version of MySQL has LiveCode been ...

Only difference is that you had the following and used sqlite vs mysql I checked the first field I have, and it actually has the entire row of data, not just the first two fields of data.

This is what goes into tData

It is being retrieved from a standard MySQL database table.

Property ID and Street Number are being put in the first field.

Property ID = 1
Street Number = 1
Street Name = White

Not sure exactly what format you want to see the data. If it comes from a MySQL database, should it not be pulled out ...

That worked for the streetname field but I still got two bits of data in the first field for streetnumber.

-- construct the SQL (this selects all the data from the specified table)
put "properties" into tTableName -- set this to the name of a table in your database
put "SELECT * FROM " & tTableName into tSQL

-- query the database
put revDataFromQuery(tab, cr, gConnectionID, tSQL) into tData
put ...

Hi thanks for that.

The lines i got from that were

put item 2 of tData into fld "fldStreetNumber"
put item 3 of tData into fld "fldStreetName"

Problem is that for fldStreetNumber, it had the values for the first two items, and nothing appeared in the fldStreetName

Is there something I am ...

I'm trying to find an example of running a database query (which I can do) and putting the data from the single record retrieved into text fields. Can someone point me to one?

It appears that preOpenStack is what I am looking for.

Yes I have done all that before. What I want to know is if there is like a pre-start condition, code that is run before all other code is run. Like an OnLoad used in VBA

Where do I put the first code to be run?

I want to do things like connect to a database, set the dimensions etc

I have just downloaded LiveCode, and just downloaded the Android SDK. I tried to select the location of Android development SDK root but it comes back with the error

"The chosen folder is not a valid Android SDK. Please ensure you have installed it correctly, and enabled support for Android 2.2 ...

Thanks Dave,

I will take a look, I am pretty proficient with php, but just wanted to know if LiveCode had a way of doing this. I did find in the Academy videos an example using ftp which I will try out.

Andrew

Hi,

It's not exactly what you want, but does give a guide to using LC and PHP - with ...