Subject Help on TIB_StoredProc
Author cyclon779
Please help.
I have a SP on my database and it looks this way:
as input parameters (date1(DATE), date2(DATE),person_id(INTEGER))
as output parameters it must return
RETURNS (
ID INTEGER,
DATAX DATE,
NR_ACT VARCHAR(16),
SOLD_FSAI NUMERIC(15,4),
INCASARE NUMERIC(15,4),
PLATA NUMERIC(15,4),
SOLD_FSA NUMERIC(15,2))

ok, the number of rows returned by the procedure could be between 3
and a few hundreds. I need to load the output into a grid and after
print it.
I use a TIB_CURSOR to execute the procedure, like this (from runtime):
======
cursor.SQL.Clear;
cursor.SQL.Add(select * from calc_sold_fsa(param1,param2,param3));
------

the problem is that in my grid only the first row is loaded. It's the
first time when I use SP this way and if someone have time for me,
please gimme some ideeas.