Subject | about selectable SPs |
---|---|
Author | duilio_fos |
Post date | 2002-10-18T11:55:21Z |
I use IBO3 with D3.
I have a SSP that works like this:
select * from mySSP('01','2002-10-18')
and I call it with the following code:
with TIBOQuery.Create(nil)
try
SQL.Add('select * from mySSP(:cod_mag,:dat_fin)');
Prepare;
ParamByName('cod_mag').AsString:=CodMag;
ParamByName('dat_fin').AsDateTime:=DFin;
Open;
First;
...
finally
Free;
end;
The problem is: I find I cannot _search_ the TDataset.
If I try to do so, using the code
SetKey;
FieldByName(...)...
Gotonearest:
I get the error message: "variant array index out of bonds".
Is there any workaround ?
TIA
Duilio Foschi
I have a SSP that works like this:
select * from mySSP('01','2002-10-18')
and I call it with the following code:
with TIBOQuery.Create(nil)
try
SQL.Add('select * from mySSP(:cod_mag,:dat_fin)');
Prepare;
ParamByName('cod_mag').AsString:=CodMag;
ParamByName('dat_fin').AsDateTime:=DFin;
Open;
First;
...
finally
Free;
end;
The problem is: I find I cannot _search_ the TDataset.
If I try to do so, using the code
SetKey;
FieldByName(...)...
Gotonearest:
I get the error message: "variant array index out of bonds".
Is there any workaround ?
TIA
Duilio Foschi