RemoveRecordset (Recordset subroutine)
Remove from a Recordset the records that are matched in input Recordset (Recordset class)
RemoveRecordset removes or "subtracts," from the method Recordset object's records, the records
in a second Recordset object.
Syntax
recordset:RemoveRecordset( recordset2)
Syntax terms
| recordset | A non-null Recordset object. |
|---|---|
| recordset2 | A non-null Recordset object, which must have the same file context as recordset. |
Usage notes
- If the recordset2 argument is null, the request is cancelled.
- Since RemoveRecordset never adds records to a Recordset, there are no lock strength requirements for the method object or the input object.
Examples
- In the following example, the result of one Find is used to eliminate records
from the result of another Find.
%threaten is object recordSet in file orders %bigCust is object recordSet in file orders find records to %threaten status = 'ARREARS' end find find records to %bigCust company ='TOXICO' end find %threaten:removeRecordset(%bigCust)
- RemoveRecordset can be thought of as subtraction,
AddRecordset as an
OR, and AndRecordset as an AND.
The missing basic logical operation is an exclusive OR, which
is not implemented as a basic method because it is expected to
be rarely needed.
However, you can achieve an exclusive OR operation with the
provided methods, as in the following example:
%first is object recordSet in foo %second is object recordSet in foo %both is object recordSet in foo ... %both = %first:copy %both:andRecordset(%second) %first:addRecordset(%second) %first:removeRecordset(%both)
And
%firstis now the exclusive OR of the original%firstand%second.