Page 1 of 1

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

Posted: Wed Jun 07, 2017 11:23 am
by 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

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

Posted: Thu Jun 08, 2017 5:35 pm
by AxWald
Hi,

Code: Select all

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