DB.DeleteRecords
Description
Description
This will delete certain records in the database depending on given parameters.
Syntax
Syntax
Function DeleteRecords(scope_text|Empty)
Parameters
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
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
See also