Message
 
 
To
03/02/2017 11:38:36
General information
Fórum:
Visual FoxPro
Category:
Programação, sintaxe e comandos
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
ID da thread:
01647432
ID da mensagem:
01647434
Views:
39
>>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 nRecno
>>
>>Is this approach, using the RECNO() in the cursor reliable?
>>
>>TIA
>
>Since nRecno is the current record number in CA_view, the record pointer isn't changed. So in a way your code only changes the work area, nothing more.

I didn't write my example correctly, you are right. I store all values of the RECNO("CA_view") in a cursor (in some rendom order). Then I select that, second cursor, and jump from one record to another. Here a modified code:
SELECT C_SomeCursor
GO TOP
do while !eof()
     nRecno = C_SomeCursor.Rec_no 
     SELECT ("CA_view")
     GOTO nRecno
     *-- Program does something to a record
     SELECT C_SomeCursor
     SKIP
enddo
In the above case, is GOTO method reliable?
"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
Previous
Next
Responder
Mapa
View