PB : Powerbuilder 7 & 9 RDBMS : Mysql 5.1.36 Windows binary 32bit DOBC : Mysql ODBC Driver 5.1.6 Problem : I had written a stored procedure in mysql which is nothing but a result set here is syntax Community : Freeware Software Developement
CREATE PROCEDURE test_rpt (in coid int) begin select co_id, it_name from item where co_id = 1; end
But if i create a datawindow report it wont run and in my databse painter also i try to run the procedure in isql windows it gives me an error "The database does not currently support retrieval of procedure text.;"
What it is? is there any way out to solve this problem.
