Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Go to deleted record
Message
 
 
To
01/04/2019 05:41:39
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01667795
Message ID:
01667804
Views:
35
>>Hi,
>>
>>I experience the following with a CA cursor. The setting DELETE is On ( SET DELETE ON )
>>1. I bookmark the recno() of the cursor (e.g. nRecno = recno(cCursorName))
>>2. I delete this record using the VFP DELETE command
>>3. I go to this record using GOTO command. GOTO nRecno (the debugger shows that the pointer is on the correct record).
>>Is this "normal"? That is, shouldn't the GOTO nRecno fail because the record has been deleted?
>
>It was always normal, for the last 30 years at least (in my experience). The goto command doesn't check anything, it just goes there if it can. The only thing it respects is eof().
>
>Movement commands (like scan, skip, locate, calculate etc) respect the filter, current tag (including partial indexes), set("deleted") and whatnot. GOTO has no respect at all, the bastard.

Thank you.
"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
Reply
Map
View

Click here to load this message in the networking platform