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
IBDACQuery and Fastreport
Re: IBDACQuery and Fastreport
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!
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!
Re: IBDACQuery and Fastreport
To call a stored procedure, you can try to use the TfrxIBDACQuery component.
Re: IBDACQuery and Fastreport
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.
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.
Re: IBDACQuery and Fastreport
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.