4D v14.3

DELETE RECORD

Home

 
4D v14.3
DELETE RECORD

DELETE RECORD 


 

DELETE RECORD {( aTable )} 
Parameter Type   Description
aTable  Table in Table where the current record will be deleted, or Default table, if omitted

DELETE RECORD deletes the current record of aTable in the process. If there is no current record for aTable in the process, DELETE RECORD has no effect. In a form, you can create a Delete Record button instead of using this command.

Notes:

  • If the current record is unloaded from memory before calling DELETE RECORD (for example, subsequent to an UNLOAD RECORD), the current selection of table is empty after the deletion occurs.
  • The DELETE RECORD command does nothing when the table is in READ ONLY mode, regardless of whether the record to be deleted is locked or not.

Deleting records is a permanent operation and cannot be undone.

If a record is deleted, the record number will be reused when new records are created. Do not use the record number as the record identifier if you will ever delete records from the database.

Example  

The following example deletes an employee record. The code asks the user what employee to delete, searches for the employee’s record, and then deletes it:

 vFind:=Request("Employee ID to delete:") ` Get an employee ID
 If(OK=1)
    QUERY([Employee];[Employee]ID =vFind) ` Find the employee
    DELETE RECORD([Employee]` Delete the employee
 End if

 
PROPERTIES 

Product: 4D
Theme: Records
Number: 58

This command changes the currrent record

 
HISTORY 

Modified: 4D 2004

 
SEE ALSO 

Locked
Triggers

 
ARTICLE USAGE

4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)