AndRecordset (Recordset subroutine) - Revision history

JAL: /* Example */

2012-11-06T22:24:01Z

Example

← Older revision		Revision as of 22:24, 6 November 2012
Line 37:		Line 37:
	Of course, identical processing could be better done with an		Of course, identical processing could be better done with an
	<var>And</var> in a <var>Find</var> statement.		<var>And</var> in a <var>Find</var> statement.
	<p class="code"> %review is object recordSet in file orders		<p class="code">%review is object recordSet in file orders
	%bigCust is object recordSet in file orders		%bigCust is object recordSet in file orders

	find records to %review		find records to %review
	status = 'REVIEW'		status = 'REVIEW'
	end find		end find

	find records to %bigCust		find records to %bigCust
	company ='TOXICO'		company ='TOXICO'
	end find		end find

	%review:andRecordset(%bigCust)		%review:andRecordset(%bigCust)
	</p>		</p>

	==See also==		==See also==
	<ul>		<ul>

JAL: /* Usage notes */

2012-11-06T22:23:41Z

Usage notes

← Older revision		Revision as of 22:23, 6 November 2012
Line 18:		Line 18:
	<ul>		<ul>
	<li>If the <var class="term">recordset2</var> argument is null, the request is cancelled.		<li>If the <var class="term">recordset2</var> argument is null, the request is cancelled.

	<li>Since <var>AndRecordset</var> never adds records to a <var>Recordset</var>, there are no lock		<li>Since <var>AndRecordset</var> never adds records to a <var>Recordset</var>, there are no lock
	strength requirements for either the method or input objects.		strength requirements for either the method or input objects.

	<li>The <var>AndRecordset</var> method can be thought of as a <var>Recordset</var> AND operation;		<li>The <var>AndRecordset</var> method can be thought of as a <var>Recordset</var> AND operation;
	<var>[[AddRecordset (Recordset subroutine)\|AddRecordset]]</var> can be thought of		<var>[[AddRecordset (Recordset subroutine)\|AddRecordset]]</var> can be thought of
Line 26:		Line 28:
	No basic method is the analog of an exclusive OR operation, but		No basic method is the analog of an exclusive OR operation, but
	you can use the basic methods to achieve an exclusive OR, as shown		you can use the basic methods to achieve an exclusive OR, as shown
	in <var>[[RemoveRecordset (Recordset subroutine)#Examples\|"~~RemoveRecordset~~ Examples"]]~~</var>~~.		in the <var>RemoveRecordset</var> [[RemoveRecordset (Recordset subroutine)#Examples\|"Examples"]] section.
	</ul>		</ul>

Dme: /* Usage notes */

2012-02-07T19:40:15Z

Usage notes

← Older revision		Revision as of 19:40, 7 February 2012
Line 23:		Line 23:
	<var>[[AddRecordset (Recordset subroutine)\|AddRecordset]]</var> can be thought of		<var>[[AddRecordset (Recordset subroutine)\|AddRecordset]]</var> can be thought of
	as an OR; and <var>[[RemoveRecordset (Recordset subroutine)\|RemoveRecordset]]</var>		as an OR; and <var>[[RemoveRecordset (Recordset subroutine)\|RemoveRecordset]]</var>
	as ~~a NOT~~.		as subtraction.
	No basic method is the analog of an exclusive OR operation, but		No basic method is the analog of an exclusive OR operation, but
	you can use the basic methods to achieve an exclusive OR, as shown		you can use the basic methods to achieve an exclusive OR, as shown

Dme at 19:38, 7 February 2012

2012-02-07T19:38:56Z

← Older revision		Revision as of 19:38, 7 February 2012
Line 1:		Line 1:
	{{Template:Recordset:AndRecordset subtitle}}		{{Template:Recordset:AndRecordset subtitle}}

	<var>AndRecordset</var> ~~&amp;ldquo;~~ANDs~~&amp;rdquo;~~ a <var>Recordset</var> object's records with the records in an		<var>AndRecordset</var> "ANDs" a <var>Recordset</var> object's records with the records in a
	~~existing~~ <var>Recordset</var> object: that is, it removes records from the		second <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 second <var>Recordset</var> object.
	==Syntax==		==Syntax==
	{{Template:Recordset:AndRecordset syntax}}		{{Template:Recordset:AndRecordset syntax}}
	===Syntax terms===		===Syntax terms===
	<table class="syntaxTable">		<table class="syntaxTable">
	<tr><th>~~%target~~</th>		<tr><th>recordset</th>
	<td>A non-null <var>Recordset</var> object variable.		<td>A non-null <var>Recordset</var> object variable.
	</td></tr>		</td></tr>
	<tr><th>~~recordsetObject~~</th>		<tr><th>recordset2</th>
	<td>A non-null <var>Recordset</var> object, which must have the same file context as ~~''%target''~~.		<td>A non-null <var>Recordset</var> object, which must have the same file context as the method object <var class="term">recordset</var>.

	</td></tr></table>		</td></tr></table>
	==Usage notes==		==Usage notes==
	<ul>		<ul>
	<li>If the <var>~~Recordset~~</var> ~~object~~ argument ~~of <var>AndRecordset</var>~~ is null, the request is		<li>If the <var class="term">recordset2</var> argument is null, the request is cancelled.
	cancelled.
	<li>Since <var>AndRecordset</var> never adds records to a <var>Recordset</var>, there are no lock		<li>Since <var>AndRecordset</var> never adds records to a <var>Recordset</var>, there are no lock
	strength requirements for either the method or input objects.		strength requirements for either the method or input objects.

Dme: /* See also */

2012-02-07T19:33:16Z

Dme: /* Usage notes */

2012-02-07T19:09:41Z

Usage notes

← Older revision		Revision as of 19:09, 7 February 2012
Line 26:		Line 26:
	as a NOT.		as a NOT.
	No basic method is the analog of an exclusive OR operation, but		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		you can use the basic methods to achieve an exclusive OR, as shown
	in <var>[[RemoveRecordset (Recordset subroutine)#Examples\|"Examples"]]</var>.		in <var>[[RemoveRecordset (Recordset subroutine)#Examples\|"RemoveRecordset Examples"]]</var>.
	</ul>		</ul>

	==Example==		==Example==

DmeWiccan: 1 revision

2011-04-14T23:59:07Z

1 revision

← Older revision	Revision as of 23:59, 14 April 2011
(No difference)

JALWiccan: 1 revision

2011-04-14T23:59:05Z

1 revision

← Older revision		Revision as of 23:59, 14 April 2011
Line 1:		Line 1:
	~~<span class="pageSubtitle"><section begin=dpl_desc/><section end=dpl_desc/></span>~~		{{Template:Recordset:AndRecordset subtitle}}
	~~[[Category~~:Recordset ~~methods\|AndRecordset subroutine]]~~
	~~<p>~~
	~~<var>~~AndRecordset~~</var> is a member of the <var>[[Recordset class\|Recordset]]</var> class.~~
	~~</p>~~

	<var>AndRecordset</var> &ldquo;ANDs&rdquo; a <var>Recordset</var> object's records with the records in an		<var>AndRecordset</var> &amp;ldquo;ANDs&amp;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.
	==Syntax==		==Syntax==
	~~<p class="syntax">%target~~:AndRecordset~~(recordsetObject)~~		{{Template:Recordset:AndRecordset syntax}}
	~~</p>~~
	===Syntax terms===		===Syntax terms===
	<table class="syntaxTable">		<table class="syntaxTable">
Line 20:		Line 15:

	</td></tr></table>		</td></tr></table>
	==Usage ~~Notes~~==		==Usage notes==
	<ul>		<ul>
	<li>If the <var>Recordset</var> object argument of <var>AndRecordset</var> is null, the request is		<li>If the <var>Recordset</var> object argument of <var>AndRecordset</var> is null, the request is
Line 53:		Line 48:
	%review:andRecordset(%bigCust)		%review:andRecordset(%bigCust)
	</p>		</p>
			==See also==
			{{Template:Recordset:AndRecordset footer}}

JALWiccan: 1 revision

2011-04-13T17:21:29Z

1 revision

← Older revision	Revision as of 17:21, 13 April 2011
(No difference)

Admin: 1 revision

2011-04-13T17:21:28Z

1 revision

← Older revision		Revision as of 17:21, 13 April 2011
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 ~~Terms~~===		===Syntax terms===
	<table class="syntaxTable">		<table class="syntaxTable">
	<tr><th>%target</th>		<tr><th>%target</th>

← Older revision		Revision as of 19:33, 7 February 2012
Line 50:		Line 50:
	</p>		</p>
	==See also==		==See also==
			<ul>
			<li><var>[[AndRecordsetNew (Recordset function)\|AndRecordsetNew]]</var>
			</ul>
	{{Template:Recordset:AndRecordset footer}}		{{Template:Recordset:AndRecordset footer}}