Message
From
03/02/2017 11:31:51
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Is Goto recno('CA_View') reliable?
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01647432
Message ID:
01647432
Views:
54
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:
TIA
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
"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