DetachWithDelete

Takes 4 parameters, TableName, Relation, OtherTableName, and a boolean expression (optional)

Usage:

TableName, Relation, OtherTableName, IfLenFld
TableName, Relation, OtherTableName, [""]
[WorkWith], Relation, OtherTableName, IfLenFld
[WorkWith], Relation, OtherTableName, [""]
TableName, Relation, OtherTableName, [WorkIf]
[WorkWith], Relation, OtherTableName, [WorkIf]

Description:

This combined Database command first calls Detach, then calls Delete with TableName.

The Relation parameter must be set to either "Child" or "Parent", and is in the context of what is OtherTableName to TableName.

Example:

WorkWith                "ToDo.Item"
SetNew "Alias", `pItem
Parents "ToDo.Item", "ToDo.List"
DetachWithDelete "Parent", "ToDo.List"
FailIfRecError
End WorkWith