Subject | Stored procedure question |
---|---|
Author | Nico Callewaert |
Post date | 2001-05-16T12:52:48Z |
Hi,
I have a stored procedure with a FOR SELECT on it. The question now is :
is there a way to see the value of the next record of the query ? To make
it more clear, it looks like this :
FOR SELECT .....
INTO :v_InvoiceNo
DO BEGIN
--> Here I have the value of v_InvoiceNo for each record, but is it
possible to "see" the value of the one that will come next ??
END
Thanks,
Nico Callewaert
I have a stored procedure with a FOR SELECT on it. The question now is :
is there a way to see the value of the next record of the query ? To make
it more clear, it looks like this :
FOR SELECT .....
INTO :v_InvoiceNo
DO BEGIN
--> Here I have the value of v_InvoiceNo for each record, but is it
possible to "see" the value of the one that will come next ??
END
Thanks,
Nico Callewaert