Is it possible to invoke procedures created in MySQL from Genexus? If so, how can I do it? Is there a guide?
Is it possible to invoke procedures created in MySQL from Genexus? If so, how can I do it? Is there a guide?
If you want to be able to call Store Procedures (SP) with GeneXus code, this you can do it in the following way:
1) At the level of the properties of the model you have a property called LIST OF REMOTE PROGRAMS (ODBC / JDBC) here you put the name of the SP separated by space, if you have more than one. (in Gx 90 this property is at the level of the DBMS)
2) From the object that you need to call the SP you simply make a classic GeneXus call
Ex: Suppose your SP is called ProcedureTest
you do: call ('ProcedureTest', & parm1, & parm2, ......)
For more information you can use the following support URL for topics related to genexus:
Greetings, I hope you find it useful.