DB.DeleteRecords

Description

This will delete certain records in the database depending on given parameters.

Syntax

Function DeleteRecords(scope_text|Empty)

Parameters

scope_text|Empty (input) - an SQL expression defining the scope to be effected by this operation; if scope is omitted, the record(s) defined by the record object setup is(are) deleted.

Return value

none

Example

Sample code

'Sample 1

DB.record.Set "Field1", 100

DB.DeleteRecords() ' all records with Field1 = 100 will be deleted

'Sample 2

DB.DeleteRecords( "Field1 < 100" ) ' all records with Field1 < 100 will be deleted