Subject | execute procedure problems |
---|---|
Author | Manuel Fresneda |
Post date | 2001-10-29T13:51:38Z |
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
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