TIBCStoredProc 'parameter mismatch for procedure'
Posted: Thu 28 Sep 2017 14:55
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 :
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 ?
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
Why it doesn't work and how to fix this problem ?