General information
Category:
Coding, syntax & commands
>>Have needed many time to "hold_recno = recno()", do something, then "go hold_recno". This does not work if recno was eof or bof. What is a good way to save the record pointers position, and then return exactly there, whether it is a good recno, bof or eof.
>>
>>Thanks - Brenda
>
>Hi Brenda,
>You can use this way to return the record pointer to exact position of a file:
>-----------------
>
>Hold_RecNo = IIF( BOF(), 0, IIF( EOF(), -1, RecNo()))
>
>...Do something...
>
>Do Case
> Case Hold_RecNo = 0
> Go Top
> If !BOF()
> Skip -1
> EndIf
> Case Hold_RecNo = -1
> Go Bottom
> If !EOF()
> Skip 1
> EndIf
> Otherwise
> Go Hold_RecNo
>EndCase
>----------------
>
>Alex
looks like a job for a HoldRecNo object, it could even store a sequence of recnos
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only