TIBCStoredProc 'parameter mismatch for procedure'

[Fabrice]

Hello,

In version 5.x I use prepareSQL for TIBCStoredProc to get the parameters list of a 'Stored procedure'.
But since version 6.X (tested on 6.1.3 / Delphi 10.2 + Firebird 3.0.2) this give me an error :

Sample :

Code: Select all

    
with   ProceduresStockee do
     begin
       StoredProcName:='count_inventory';

       PrepareSql;
     
          Params[0].DataType:=ftstring;
          Params[0].ParamType:=ptInput;
          Params[0].AsString:='Avalue';
          Params[1].DataType:=ftinteger;
          Params[1].ParamType:=ptOUtput;
         ExecProc;
     result:=Params[2].asinteger;      
end;

Code: Select all

object ProceduresStockee: TIBCStoredProc
  Connection = MyDatabase
  AutoCalcFields = False
  Left = 235
  Top = 88
end

PrepareSql => Give me an error 'Dynamic SQL error input parameter mismatch for procedure "count_inventory"

Why it doesn't work and how to fix this problem ?

[ViktorV]

We have already fixed the issue with occurrence of the 'parameter mismatch for procedure' error . This fix will be included in the next build of IBDAC, which we are planning to release within within 1-2 days.

[ViktorV]

The new IBDAC 6.1.4 with a fix for this issue is already available for download now.