Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Go to deleted record
Message
From
31/03/2019 19:37:11
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01667795
Message ID:
01667796
Views:
45
>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?
>
>TIA

GOTO is deterministic. It will go to the record you indicate.

Using SKIP or other movement operation will honor the DELETED() flag.

VFP9 help includes this:
Note:
GOTO [RECORD] nRecordNumber works with physical records. Thus, it ignores SET DELETED or SET FILTER settings. If the specified physical record number exists in the table, the system moves the pointer to the record. This occurs even if that record has been marked for deletion or may be marked for exclusion by any filter in effect on the table. However, GOTO TOP/BOTTOM works with logical record positions. Therefore, you must respect the SET DELETED, SET FILTER and SET ORDER settings."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform