fastDelete Method

Class: Db

Description

This method deletes multiple records from temporary tables. This method does not call the filer when deleting the record(s). Therefore, do not use this method for tables that have indexes, triggers, or journal definitions linked to them.

To delete a single record from the database, use the Db.delete method.

As of Profile version 6.3, this method supports lowercase variables, object.property, and system variables within the host variable syntax. PSL maps these variables and object references into uppercase host variables.

Syntax

Db.fastDelete(literal String table,literal String accessKeys)

Parameters

table

A valid database table name.

accessKeys

A comma-separated list of access keys for the table.

Returns

Void

When Became Available

v6.0

Example

// Delete a row from a table

do Db.fastDelete(“ACH”,”COID=:COID”)

 

*  Db.fastDelete deletes the rows in the  table.

It does not delete the table definition.