0
Good afternoon.
I have the following storedprocedure in Mysql..:
DELIMITER $$
CREATE DEFINER=`ricardo`@`%` PROCEDURE `teste2`()
BEGIN
Select * from Tabela;
END
As I call this storedprocedure by DELPHI 7 ?
I’m using the ZEOS components.
I’ve tried with the zQuery..: Call teste2; open.. exeqsql.. didn’t work.
I’ve tried with the Zstoredproc1.. also did not work.. it neither click on the properti the name of the storedprocedure.
I know I could do a direct sql in the component, but the one described above is just an example. Procedure performs several operations and at the end there is an sql to be returned.
However, even in the above example, a simple sql, could not return the storedprocedure in Delphi to be viewed in a grid.
Thank you for your attention :)
Use
Open();
instead ofExecSQL;
(useQuery
)– Ilyes
Good afternoon @Sami . As I mentioned in the post, I have tried to use both the open and the exeqsql with several different instructions inside, but without success.. Anyway. Thank you for your attention :)
– Ricardo M.Souza
You must use "Active"
– Ilyes