AndRecordset (Recordset subroutine): Difference between revisions
m (1 revision) |
m (1 revision) |
||
| Line 5: | Line 5: | ||
</p> | </p> | ||
<var>AndRecordset</var> “ANDs” a <var>Recordset</var> object's records with the records in an | <var>AndRecordset</var> &ldquo;ANDs&rdquo; a <var>Recordset</var> object's records with the records in an | ||
existing <var>Recordset</var> object: that is, it removes records from the | existing <var>Recordset</var> object: that is, it removes records from the | ||
method <var>Recordset</var> object that are not also on the input <var>Recordset</var> object. | method <var>Recordset</var> object that are not also on the input <var>Recordset</var> object. | ||
| Line 11: | Line 11: | ||
<p class="syntax">%target:AndRecordset(recordsetObject) | <p class="syntax">%target:AndRecordset(recordsetObject) | ||
</p> | </p> | ||
===Syntax | ===Syntax terms=== | ||
<table class="syntaxTable"> | <table class="syntaxTable"> | ||
<tr><th>%target</th> | <tr><th>%target</th> | ||
Revision as of 17:21, 13 April 2011
<section begin=dpl_desc/><section end=dpl_desc/>
AndRecordset is a member of the Recordset class.
AndRecordset “ANDs” a Recordset object's records with the records in an existing Recordset object: that is, it removes records from the method Recordset object that are not also on the input Recordset object.
Syntax
%target:AndRecordset(recordsetObject)
Syntax terms
| %target | A non-null Recordset object variable. |
|---|---|
| recordsetObject | A non-null Recordset object, which must have the same file context as %target. |
Usage Notes
- If the Recordset object argument of AndRecordset is null, the request is cancelled.
- Since AndRecordset never adds records to a Recordset, there are no lock strength requirements for either the method or input objects.
- The AndRecordset method can be thought of as a Recordset AND operation; AddRecordset can be thought of as an OR; and RemoveRecordset as a NOT. No basic method is the analog of an exclusive OR operation, but you can use the basic methods to achieve such an OR, as shown in "Examples".
Example
In the following example, the result of one Find is used to limit the result of another Find. Of course, identical processing could be better done with an And in a Find statement.
%review is object recordSet in file orders %bigCust is object recordSet in file orders find records to %review status = 'REVIEW' end find find records to %bigCust company ='TOXICO' end find %review:andRecordset(%bigCust)