How to take advantage of new features in IBDAC 6.1?

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
sugi
Posts: 43
Joined: Wed 07 Dec 2016 02:05

How to take advantage of new features in IBDAC 6.1?

Post by sugi » Sat 23 Sep 2017 02:47

Hello,

I am interested in these features from IBDAC 6.1 :
  • 1. Support for Firebird 3 packages is added
    2. The WireCompression connection parameter for Firebird 3 is supported
Are there any settings to applied on IBDAC components to use those features?

I have used IBDAC prior ver 6.1 with Firebird 3, will update to IBDAC ver 6.1 offers noticeable performance?

Thanks & regards,
Sugi.

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

Re: How to take advantage of new features in IBDAC 6.1?

Post by ViktorV » Mon 25 Sep 2017 09:08

1. In IBDAC 6.1 you can work with Packages, which appeared in Firebird 3. For example:

Code: Select all

IBCStoredProc.SQL.Text := 'EXECUTE PROCEDURE APP_VAR.SET_DATERANGE(:ADATEBEGIN, :ADATEEND)';
IBCStoredProc.ParamByName('ADATEBEGIN').asString := '01.01.1981';
IBCStoredProc.ParamByName('ADATEEND').asString := '01.06.1981';
IBCStoredProc.ExecProc;
IBCQuery.SQL.Text := 'select * from emp ' +
  'where HIREDATE between APP_VAR.GET_DATEBEGIN() ' +
  'and APP_VAR.GET_DATEEND(); ';
IBCQuery.Open;
2. To enable Wirecompression on the client side, you should add the string "WireCompression=true" to the IBCConnection.Params. For example:

Code: Select all

  IBCConnection.Params.Add('WireCompression=true');
We recommend using the latest IBDAC version, as it includes a lot of changes and improvements, due to which its functionality became more stable and efficient.

Post Reply