Subject about selectable SPs
Author duilio_fos
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