DeleteFingerprints

Deletes all fingerprints that are returned by the SQL statement in the parameter

Member of namespace

FingerprintMaintenance

Syntax

bool DeleteFingerprints (string SQL)

Parameters

SQL: Type: string; SQL statement to return a recordset of fingerprints to be deleted.

Parameters

SQL statement that is used to return a recordset of fingerprints that must be deleted.

Returns

Always True.

Level

Any level.

Details

Deletes all fingerprints that are returned by the query that is specified in the parameter. A smart parameter can be used.

Example:

Access - DeleteFingerprints("SELECT * FROM Template WHERE tp_LastHit < dateadd("d",-30,NOW)")
SQL - DeleteFingerprints("SELECT * FROM Template WHERE tp_LastHit < dateadd(d,-2,GETDATE())")
Oracle- DeleteFingerprints("SELECT * FROM Template WHERE tp_LastHit < TRUNC(SYSDATE) - 30")