Re: SQLRPGLE - scrollable cursor, set at a specific record

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 08/08/2016 10:48:51
PM:

All that works just fine. Where I am having trouble is with the first
cycle.

... if %parms = 1 and pID <> ' ';_// exec sql fetch ????? from
C1 into :wRecordDS ???where HID = :pID;_ else;
exec sql fetch first from C1 into :wRecordDS; endif; ...

If there is a parm I wish to position the file to the key provided. I
can't figure out how to do it.

FAIK, once the scrollable cursor is opened, it can only be
scrolled to the top, bottom, or by positive or negative relative position
-- for example:

exec sql fetch relative :iPos from IMIBALBRSM_IM02_View1p;

For positioning to a specific key value, I close and reopen the
cursor starting at that key. To scroll backwards from a positioned key
again requires closing and reopening the cursor using a new key value.

Sincerely,

Dave Clark