When you create a DELETE statement, you select criteria that indicates which records from that table are to be removed. You view the criteria in the Criteria Specification tab. You set the criteria by right-clicking a column name, selecting Add Criterion, and completing the Specify Criterion dialog box. You can define late-binding parameters or specific values in the criteria logic. Values must be of the appropriate data type.
If you use a DELETE statement in a database, the information cannot be recovered.
NOTE: A DELETE statement can only be used in a grid object within a Proficy Portal display.