deleterecordandchildren
deleterecordandchildren
DATABASE
,
KEYFIELD
,
KEYVALUE

The deleterecordandchildren statement This deletes the current record from the active database and all the records in another database that have a value in the key field that is equal to the key value.

Parameters

This statement has three parameters:

database – Name of database containing the “child” records.

keyfield – Name of the field you want to search in.

keyvalue – Value in records to be deleted.

Description

This statement deletes the current record from the active database and all the records in another database that have a value in the key field that is equal to the key value.

This example deletes all the records from the My Contacts database that have a name in the Organization field that exactly matches the value in the Company field in the current record.

    DeleteRecordAndChildren "My Contacts", "Organization", Company

In other words, it deletes the company from both the current database and the My Contacts database.

See Also

- deletechildren -- deletes all the records in another database that have a value in the key field that is equal to the key value.
- deleterecchildrenwarn -- warns you before deleting the current record from the active database and all the records in another database that have a value in the key field that is equal to the key value.
- post -- assigns a value to a field in another database.
- postadjust -- adjusts the value of a numeric field in another database, by adding (or subtracting) a number.

History

Version | Status | Notes
10.0 | No Change | Carried over from Panorama 6.0.