Stored Procedures in Button Level

Applications Forms
#1

Hi Friends,

         How to call the stored procedure in Buttons. For Eg: Button Name: CHECK_BTN . Button Type: PHP

       Eg:

               Stored Procedure Name:   call_simplePro();

       Please give me the right syntax and give example ...
#2

You mean a mysql stored procedure or an oracle stored procedure or… well you get the point…
That is pretty standard php (mysql): http://www.php.net/manual/en/mysqli.quickstart.stored-procedures.php
(oracle): http://www.oracle.com/technetwork/articles/fuecks-sps-095636.html etc… use your friendly neighbourhood google… :slight_smile:

#3

Hi ,

            I am using MYSQL Stored Procedure.. Give me a example of my problem
#4

Did I not I thought I gave you links… Here is another one…
http://dev.mysql.com/doc/refman/5.0/en/call.html
Just do a CALL statement with the proper parameters for you mysql procedure…

$mysqli = new mysqli(“example.com”, “user”, “password”, “database”);
$mysqli->query(“CALL call_simplePro()”);
If you can do a statement in your mysql workbench (or commandline) you can basically do the same in php…