AndRecordsetNew (Recordset function) - Revision history

JAL: /* Example */

2012-11-06T22:25:05Z

Example

← Older revision		Revision as of 22:25, 6 November 2012
Line 43:		Line 43:
	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
	%bigReview is object recordSet in file orders		%bigReview 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

	%bigReview = %review:andRecordsetNew(%bigCust)		%bigReview = %review:andRecordsetNew(%bigCust)
	</p>		</p>

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

JAL2: /* Usage notes */

2012-02-22T22:34:26Z

Usage notes

← Older revision		Revision as of 22:34, 22 February 2012
Line 34:		Line 34:
	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>~~[[RemoveRecordsetNew (Recordset function)#Examples\|"~~RemoveRecordsetNew~~ Examples"]]</var>.		in the [[RemoveRecordsetNew (Recordset function)#Examples\|"Examples"]] section of <var>RemoveRecordsetNew</var>.
	</ul>		</ul>

Dme at 19:47, 7 February 2012

2012-02-07T19:47:36Z

← Older revision		Revision as of 19:47, 7 February 2012
Line 10:		Line 10:
	===Syntax terms===		===Syntax terms===
	<table class="syntaxTable">		<table class="syntaxTable">
	<tr><th>%~~target~~</th>		<tr><th>%outRecordset</th>
	<td>The <var>Recordset</var> object ~~variable~~ created by this method.		<td>The <var>Recordset</var> object created by this method.
	</td></tr>		</td></tr>
	<tr><th>~~%rs~~</th>		<tr><th>recordset</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 <var class="term">%outRecordset</var>.
	</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 <var class="term">%outRecordset</var>.

	</td></tr></table>		</td></tr></table>
Line 24:		Line 24:
	<li>The <var>AndRecordsetNew</var> method is only available in <var class="product">Sirius Mods</var> 7.1 and later.		<li>The <var>AndRecordsetNew</var> method is only available in <var class="product">Sirius Mods</var> 7.1 and later.
	<li>The <var>LockStrength</var> and <var>LoopLockStrength</var> of the output Recordset object is		<li>The <var>LockStrength</var> and <var>LoopLockStrength</var> of the output Recordset object is
	the same as that of the method object ~~(%rs)~~.		the same as that of the method object <var class="term">recordset</var>.
	<li>If the <var>~~Recordset~~</var> ~~object~~ argument ~~of <var>AndRecordsetNew</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>AndRecordsetNew</var> never adds records to a <var>Recordset</var>, there are no lock		<li>Since <var>AndRecordsetNew</var> never adds records to a <var>Recordset</var>, there are no lock
	strength requirements for either the method or input object.		strength requirements for either the method or input object.

Dme: /* Usage notes */

2012-02-07T19:40:44Z

Usage notes

← Older revision		Revision as of 19:40, 7 February 2012
Line 32:		Line 32:
	<var>[[AddRecordsetNew (Recordset function)\|AddRecordsetNew]]</var> can be thought of		<var>[[AddRecordsetNew (Recordset function)\|AddRecordsetNew]]</var> can be thought of
	as an OR; and <var>[[RemoveRecordsetNew (Recordset function)\|RemoveRecordsetNew]]</var>		as an OR; and <var>[[RemoveRecordsetNew (Recordset function)\|RemoveRecordsetNew]]</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: /* See also */

2012-02-07T19:32:45Z

Dme: /* Usage notes */

2012-02-07T19:31:40Z

Usage notes

← Older revision		Revision as of 19:31, 7 February 2012
Line 34:		Line 34:
	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>[[RemoveRecordsetNew (Recordset function)#Examples\|"Examples"]]</var>.		in <var>[[RemoveRecordsetNew (Recordset function)#Examples\|"RemoveRecordsetNew Examples"]]</var>.
	</ul>		</ul>

JAL2 at 16:04, 15 April 2011

2011-04-15T16:04:14Z

← Older revision		Revision as of 16:04, 15 April 2011
Line 1:		Line 1:
	{{Template:Recordset:AndRecordsetNew subtitle}}		{{Template:Recordset:AndRecordsetNew subtitle}}

	<var>AndRecordsetNew</var> &~~amp;amp;~~ldquo;ANDs&~~amp;amp;~~rdquo; a <var>Recordset</var> object's records with the records in an		<var>AndRecordsetNew</var> “ANDs” a <var>Recordset</var> object's records with the records in an
	another <var>Recordset</var> object and produces a new <var>Recordset</var> object that contains the		another <var>Recordset</var> object and produces a new <var>Recordset</var> object that contains the
	records in both <var>Recordsets</var>.		records in both <var>Recordsets</var>.

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:AndRecordsetNew subtitle}}
	~~[[Category~~:Recordset ~~methods\|AndRecordsetNew function]]~~
	~~<p>~~
	~~<var>~~AndRecordsetNew~~</var> is a member of the <var>[[Recordset class\|Recordset]]</var> class.~~
	~~</p>~~

	<var>AndRecordsetNew</var> &ldquo;ANDs&rdquo; a <var>Recordset</var> object's records with the records in an		<var>AndRecordsetNew</var> &amp;ldquo;ANDs&amp;rdquo; a <var>Recordset</var> object's records with the records in an
	another <var>Recordset</var> object and produces a new <var>Recordset</var> object that contains the		another <var>Recordset</var> object and produces a new <var>Recordset</var> object that contains the
	records in both <var>Recordsets</var>.		records in both <var>Recordsets</var>.
	It does the same processing as <var>[[AndRecordset (Recordset subroutine)\|AndRecordset]]</var>,		It does the same processing as <var>[[AndRecordset (Recordset subroutine)\|AndRecordset]]</var>,
	but it produces a new output <var>Recordset</var> and leaves the two input <var>Recordsets</var> unmodified.		but it produces a new output <var>Recordset</var> and leaves the two input <var>Recordsets</var> unmodified.
	==~~AndRecordset syntax~~==		==Syntax==
	~~<p class="pre"> %target = %rs~~:~~AndRecordset(recordsetObject)~~		{{Template:Recordset:AndRecordsetNew syntax}}
	~~</p>~~
	===Syntax terms===		===Syntax terms===
	<table class="syntaxTable">		<table class="syntaxTable">
Line 25:		Line 20:

	</td></tr></table>		</td></tr></table>
	==Usage ~~Notes~~==		==Usage notes==
	<ul>		<ul>
	<li>The <var>AndRecordsetNew</var> method is only available in <var class="product">Sirius Mods</var> 7.1 and later.		<li>The <var>AndRecordsetNew</var> method is only available in <var class="product">Sirius Mods</var> 7.1 and later.
Line 63:		Line 58:
	%bigReview = %review:andRecordsetNew(%bigCust)		%bigReview = %review:andRecordsetNew(%bigCust)
	</p>		</p>
			==See also==
			{{Template:Recordset:AndRecordsetNew footer}}

JALWiccan: 1 revision

2011-04-13T17:21:29Z

1 revision

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

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