IBDACQuery and Fastreport

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
minkus
Posts: 5
Joined: Sat 15 Oct 2005 08:30
Contact:

IBDACQuery and Fastreport

Post by minkus » Sun 04 Jun 2017 16:16

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

minkus
Posts: 5
Joined: Sat 15 Oct 2005 08:30
Contact:

Re: IBDACQuery and Fastreport

Post by minkus » Tue 06 Jun 2017 07:58

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!

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: IBDACQuery and Fastreport

Post by ViktorV » Tue 06 Jun 2017 10:22

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

minkus
Posts: 5
Joined: Sat 15 Oct 2005 08:30
Contact:

Re: IBDACQuery and Fastreport

Post by minkus » Tue 06 Jun 2017 17:37

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.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: IBDACQuery and Fastreport

Post by ViktorV » Wed 07 Jun 2017 10:34

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.

Post Reply