Subject | Help on TIB_StoredProc |
---|---|
Author | cyclon779 |
Post date | 2005-10-17T17:38:14Z |
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.
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.