Devart Forums

Hi, How can i run stored procedure to fill data for report using TfrxIBDACQuery

ex. execute procedure MyProc(:Param1);

or

insert into table (field1, field2)
select field1, field2 from MyProc2(:Param2)

Thanks

Hi!

I need to run stored procedure from tfrxibdacQuery before runing the report.
For example in FireDAC exists a frxStoredProc Component, that I didn't see in frxIBDac componens.

Is there are a way to do this ?

Thanks!

To call a stored procedure, you can try to use the TfrxIBDACQuery component.

Hello, Victor!

Didn't work!

work only if the procedure return rows and it is possible to call select, another way get an error.

how to run this statement "EXECUTE PROCEDURE MYPROC(:MyParam)" ?

Thanks.

In order to get a detailed answer, please compose a small sample demonstrating the required functionality using standard FireDAC components and send it to us using the contact form https://www.devart.com/company/contactform.html including scripts for creating and filling database objects.