The Delete object permits the Procedure-generated deletion of the data
of an entire database table or Search-selected data from any database table
shown in the Palette's Resources other than a Transaction table i.e. TXDetail or OpenItem.
Upon landing in the Workspace, the Delete object will be displayed
with a single area: a header field to receive the database table name.
Caution:
- You will wipe out the entire content of the database table unless you specify
the Search criteria in the Inspector. You may also wish to
use the Success? object
modifier, located in the Inspector's Error Checking view. If it is
useful to your Procedure, you should attach appropriate actions to
the Yes and No
exits.
- Read up on the Abort
... setting and the use of the Packet option.
Please Note:
- Delete - not available to Transaction Tables but
is available from
Transaction Procedures.
- You may not Delete data in Transaction database tables using
this object. However, you can cause a Delete in Subledger or
Global database tables as part of most Transaction Procedure options. Should
you drag
the Delete object into a Procedure Workspace you will notice that, while
this object is selected, the TXDetail and OpenItem table names
are disabled in the Transaction section within the Resources - Source area
of the Palette.
Go to:
Index
Table of Contents