SiMX Help‎ > ‎The Target Platform‎ > ‎Objects‎ > ‎DBCreator Object‎ > ‎

DBCreator.DeleteRecords


Platform Objects


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 


See also

Platform Objects and Methods
DB.sort
DB.AppendFinish
DBCreator.Find