deletechildren
deletechildren
DATABASE
,
KEYFIELD
,
KEYVALUE

The deletechildren statement deletes 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 all the records in another database that have a value in the key field that is equal to the key value. Note: As a side effect, all remaining records in the target database will be selected.

This example deletes all the records from the My Contacts database that have the value `"Acme"` in the Organization field. It will not delete a record which contains `"Acme Holdings"`.

    DeleteChildren "My Contacts", "Organization", "Acme"

See Also

- 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.
- deleterecordandchildren -- 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.
- 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.