MySQL Stored procedure...

Databases
1

Hi all,
i’m evaluating XOJO with the internal MySQL mechanism (not ODBC) to connect / select, update and insert records on a MySQL DB/Table.
Is there any chance to use MySQL stored procedures with XOJO ? F.e. to call a stored procedure and pass parameters to the stored procedure ?
Any example would be helpful…
Thx
Fenderbaum

2

Hi Henning and welcome to Xojo.

Calling a stored procedure is a database call like any other. I do it all the time (with PostgreSQL, but that doesn’t make a difference).

Dim SQL as String=“Select * from myFancyFunction(1stparameter,2ndParameter)”
dim RS as recordset=myMSQLConnection.SQLSelect(SQL)

That’s it.

3

I normally use call keyword, so it would be:

Dim SQL as String=“CALL myFancyFunction(1stparameter,2ndParameter)”
dim RS as recordset=myMSQLConnection.SQLSelect(SQL)

4

Moin Leute…
Danke !!
Gru
Henning