This case is using Cursor Adapter.
I have a routine in a method where a user adds a bunch of new records to the CA view/cursor. Then the code needs to "jump" from some record to another record (in this CA View). Note that the PK is not yet set in this view/cursor (since these are new records and have not been saved yet).
My code is using the following approach.
When I need to go from a record to another record I use RECNO("CA_view") stored into a variable.
For example:
nRecno = recno("CA_view")
SELECT ("CA_view")
GOTO nRecnoIs this approach, using the RECNO() in the cursor reliable?
TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
