Zeos stored procedure "parameter mismatch" errors
lazarus / 16-Databases

----------------------------------------------------------------------
JD · 2009-09-06 15:29

I have written some code to restrict results retrieved from a Firebird
2.1 table based on a start date and an end date. I am having problems
passing string parameters to a Firebird stored procedure that fetches
these results using ZeosLib components. The stored procedure with
string parameters works perfectly when executed from inside the
Firebird database but it raises a "parameter mismatch" exception from
inside my code.

Code: [Select]  with zsprRapports do
  begin
    Close;
    //ParamByName('DEBUT_PERIODE').AsString := '''01.01.2009''';
    //ParamByName('FIN_PERIODE').AsString := '''31.12.2009''';
    StoredProcName := 'UTILISATION_FONDS_SOLIDARITE';
    ParamByName('DEBUT_PERIODE').AsString := '''01.01.2009''';
    ParamByName('FIN_PERIODE').AsString := '''31.12.2009''';
    Open;
    First;

    // Compute the number of rows to be added to the StringGrid BEFORE
filling the grid
    SGrid1.RowCount := RecordCount + SGrid1.FixedRows;

    // Fill the string grid with the results of the stored procedure
    while not EOF do
    begin
      for intGridCol := 0 to FieldCount - 1 do
      begin
        SGrid1.Cells[intGridCol + SGrid1.FixedCols, intGridRow +
SGrid1.FixedRows] :=
          Fields[intGridCol].AsString;
      end;
      Next;
      Inc(intGridRow);
    end;

    Close;
  end;


I've tried using date parameters in the stored procedure & in my code
but the result is the same.

Any pointers to help me get round this problem will be greatly
appreciated.

----------------------------------------------------------------------
CAMITHbIK · 2009-11-16 10:34

Try change input parameters tyte in firebird's SP from DATE to
CHAR(10)
and inside firebird's SP cast its as DATE.

----------------------------------------------------------------------
clauslack · 2009-11-16 12:34

if DataType of DEBUT_PERIODE = time

try
ParamByName('DEBUT_PERIODE').asdate:=StrToDate('01/01/2009');

Regards