How to call a stored procedure in an external MySQL DB?

[greg falda]

Dear All

Assume that I have connected from LiveCode to an external MySQL database using code like:

Code: Select all

-- connect to the database
put revOpenDatabase("MySQL", tDatabaseAddress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult

as described in the lesson:
http://lessons.livecode.com/m/4071/l/70 ... l-database

Assume that the database has some stored procedures. How can I call such a MySQL stored procedure from LiveCode using this connection?

Please advise.

best
greg falda

[AxWald]

Hi,

Code: Select all

   put "CALL `myStoredProcedure`;" into StrSQL
   get revdb_execute(myDBID,StrSQL)

Have fun!