Stored Procedure Execution with output parameter

[francis6425]

Hi,

Can any one advise on how to call the stored procedure with input and output parameter from Livecode.
I can't find any example on it.

I've a stored procedure that helps to insert a new row in a MYSQL table and then set the primary key to the output parameter.
Using PHP, I'm able to successfully pass input parameters to be inserted and then get the key back from the output parameter.
However I'm so far no able to do it successfully using livecode. Can any experts provide a short sample of how to do it in livecode.

Regards,
Francis

[MaxV]

Do you want a program with a GUI, or just a script?
If you want a script, note this:

Code: Select all

myscript opt1 opt2

the variable $1 contains opt1
the variable $2 contains opt2