Please show us the source for the PROC and the SQL trace.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Manuel Fresneda" <manuelfresnedaguerra@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, October 29, 2001 6:51 AM
Subject: [IBO] execute procedure problems


> Hi all.
>
> I have the next code:
>
> with tDatos.pCalculo do
> begin
> Close;
> SQL.Clear;
> SQL.Add('execute procedure poliza_polmod :polpro,:polcod');
> ParamByName('polpro').Value := AEntero(pcaccpro.Text);
> ParamByName('polcod').Value := AEntero(pcacccod.Text);
> ExecProc;
> Modalidad := FieldByName('polmod').AsInteger;
> end;
>
> if the database is in dialect 1 all is right, but if i change it
> to dialect 3 then i get the following:
>
> ISC ERROR CODE:335544569
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> parameter mismatch for procedure POLIZA_POLMOD
>
>
> I use Delphi6+Sp1 IBO_4_2_F IB6
>
> Someone knows why.
>
> Thanks
>