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.