General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only