DELETE_RECORD_WHERE Function
Function Type | Predefined function | |
Syntax | DELETE_RECORD_WHERE( <table>, <stringSQLWhere> ) | |
Description | Performs similar to the DELETE_RECORD function, except this function deletes records based on an SQL WHERE statement (rather than mapped keys). | |
Argument | Description | |
<table> | Table from which you want to delete records. | |
<stringSQLWhere> | Where clause that determines which records to delete. | |
Returns | Boolean true = Records successfully deleted. | |
Example | This example deletes the records in Target.Table1 where the key fields match the key field that it sets. Calling this macro will delete all records in Target.Table1 where "key" is equal to "37". DELETE_RECORD_WHERE(Target.Table1,"key=37") | |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*