DBDELETE() Mark a record for deletion ------------------------------------------------------------------------------ Syntax DBDELETE() --> NIL Returns DBDELETE() always returns NIL. Description DBDELETE() marks the current record as deleted. Records marked for deletion can be filtered using SET DELETED or removed from the file using the PACK command. DBDELETE() performs the same function as the standard DELETE command with a scope of the current record. For more information, refer to the DELETE command. Notes . Logical records: If the global _SET_DELETED status is true (.T.), deleted records are not logically visible. That is, database operations which operate on logical records will not consider records marked for deletion. Note, however, that if _SET_DELETED is true (.T.) when the current record is marked for deletion, the record remains visible until it is no longer the current record. . Network environment: For a shared database on a network, DBDELETE() requires the current record to be locked. For more information, refer to the "Network Programming" chapter of the Programming and Utilities Guide. Examples . The following example deletes a record after a successful record lock: cLast := "Winston" DBUSEAREA( .T., "DBFNTX", "Sales", "Sales", .T. ) DBSETINDEX( "LASTNAME" ) // IF ( Sales->(DBSEEK(cLast)) ) IF Sales->( RLOCK() ) Sales->( DBDELETE() ) ? "Record deleted: ", Sales->( DELETED() ) ELSE ? "Unable to lock record..." ENDIF ELSE ? "Not found" ENDIF Files Library is CLIPPER.LIB.
See Also: DBRECALL() DELETE RECALL