RemoveRecordsetNew (Recordset function) - Revision history

JAL at 23:56, 6 November 2012

2012-11-06T23:56:14Z

← Older revision		Revision as of 23:56, 6 November 2012
Line 4:		Line 4:
	in a second <var>Recordset</var> object, producing a new <var>Recordset</var> object that		in a second <var>Recordset</var> object, producing a new <var>Recordset</var> object that
	contains all the records in the first <var>Recordset</var>, but not the second. It does the same processing as <var>[[RemoveRecordset (Recordset subroutine)\|RemoveRecordset]]</var>, but it produces a new output <var>Recordset</var> and leaves the two input <var>Recordset</var>s unmodified.		contains all the records in the first <var>Recordset</var>, but not the second. It does the same processing as <var>[[RemoveRecordset (Recordset subroutine)\|RemoveRecordset]]</var>, but it produces a new output <var>Recordset</var> and leaves the two input <var>Recordset</var>s unmodified.

	==Syntax==		==Syntax==
	{{Template:Recordset:RemoveRecordsetNew syntax}}		{{Template:Recordset:RemoveRecordsetNew syntax}}

	===Syntax terms===		===Syntax terms===
	<table class="syntaxTable">		<table class="syntaxTable">
	<tr><th>%outRecordset</th>		<tr><th>%outRecordset</th>
	<td>The <var>Recordset</var> object created by this method.		<td>The <var>Recordset</var> object created by this method.</td></tr>
	</td></tr>
	<tr><th>recordset</th>		<tr><th>recordset</th>
	<td>A non-null <var>Recordset</var> object, which must have the same file context as <var class="term">%outRecordset</var>.		<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>recordset2</th>		<tr><th>recordset2</th>
	<td>A non-null <var>Recordset</var> object, which must have the same file context as <var class="term">%outRecordset</var> and the method object, <var class="term">recordset</var>.		<td>A non-null <var>Recordset</var> object, which must have the same file context as <var class="term">%outRecordset</var> and the method object, <var class="term">recordset</var>.</td></tr>
	</td></tr></table>		</table>

	==Usage notes==		==Usage notes==
	<ul>		<ul>
	<li>The <var>RemoveRecordsetNew</var> method is only available in <var class="product">Sirius Mods</var> 7.1 and later.		<li>The <var>RemoveRecordsetNew</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 <var>Recordset</var> object is		<li>The <var>LockStrength</var> and <var>LoopLockStrength</var> of the output <var>Recordset</var> object is
	the same as that of the method object, <var class="term">recordset</var>.		the same as that of the method object, <var class="term">recordset</var>.

	<li>If the <var class="term">recordset2</var> argument is null, the request is		<li>If the <var class="term">recordset2</var> argument is null, the request is
	cancelled.		cancelled.

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

	==Examples==		==Examples==
	<ul>		<ol>
	<li>In the following example, the result of one <var>Find</var> is used to eliminate records		<li>In the following example, the result of one <var>Find</var> is used to eliminate records
	from the result of another <var>Find</var>.		from the result of another <var>Find</var>.
	<p class="code"> %arrears is object recordSet in file orders		<p class="code">%arrears is object recordSet in file orders
	%bigCust is object recordSet in file orders		%bigCust is object recordSet in file orders
	%threaten is object recordSet in file orders		%threaten is object recordSet in file orders

	find records to %arrears		find records to %arrears
	status = 'ARREARS'		status = 'ARREARS'
	end find		end find

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

	%threaten = %arrears:removeRecordset(%bigCust)		%threaten = %arrears:removeRecordset(%bigCust)
	</p>		</p>

	<li><var>RemoveRecordsetNew</var> can be thought of as subtraction,		<li><var>RemoveRecordsetNew</var> can be thought of as subtraction,
	<var>[[AddRecordsetNew (Recordset function)\|AddRecordsetNew]]</var> as an		<var>[[AddRecordsetNew (Recordset function)\|AddRecordsetNew]]</var> as an
Line 56:		Line 62:
	However, you can achieve such an exclusive OR operation with the		However, you can achieve such an exclusive OR operation with the
	provided methods, as in the following example:		provided methods, as in the following example:
	<p class="code"> %first is object recordSet in foo		<p class="code">%first is object recordSet in foo
	%second is object recordSet in foo		%second is object recordSet in foo
	%xor is object recordSet in foo		%xor is object recordSet in foo
	...		...
	%xor = %first:addRecordsetNew(%second): -		%xor = %first:addRecordsetNew(%second): -
	removeRecordset(%first:andRecordsetNew(%second))		removeRecordset(%first:andRecordsetNew(%second))
	</p>		</p>
	And <code>%xor</code> is now the exclusive OR of the original <code>%first</code>		And <code>%xor</code> is now the exclusive OR of the original <code>%first</code>
	and <code>%second</code>.		and <code>%second</code>.
	</ul>		</ol>

	==See also==		==See also==

JAL2: /* Usage notes */

2012-02-22T22:53:54Z

Usage notes

← Older revision		Revision as of 22:53, 22 February 2012
Line 22:		Line 22:
	<li>The <var>RemoveRecordsetNew</var> method is only available in <var class="product">Sirius Mods</var> 7.1 and later.		<li>The <var>RemoveRecordsetNew</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 <var>Recordset</var> object is		<li>The <var>LockStrength</var> and <var>LoopLockStrength</var> of the output <var>Recordset</var> object is
	the same as that of the method object <var class="term">recordset</var>.		the same as that of the method object, <var class="term">recordset</var>.
	<li>If the <var class="term">recordset2</var> argument is null, the request is		<li>If the <var class="term">recordset2</var> argument is null, the request is
	cancelled.		cancelled.
Line 28:		Line 28:
	strength requirements for the either method or input object.		strength requirements for the either method or input object.
	</ul>		</ul>

	==Examples==		==Examples==
	<ul>		<ul>

JAL2: /* Syntax terms */

2012-02-22T22:35:54Z

Syntax terms

← Older revision		Revision as of 22:35, 22 February 2012
Line 15:		Line 15:
	</td></tr>		</td></tr>
	<tr><th>recordset2</th>		<tr><th>recordset2</th>
	<td>A non-null <var>Recordset</var> object, which must have the same file context as <var class="term">%outRecordset</var> and the method object <var class="term">recordset</var>.		<td>A non-null <var>Recordset</var> object, which must have the same file context as <var class="term">%outRecordset</var> and the method object, <var class="term">recordset</var>.
	</td></tr></table>		</td></tr></table>

	==Usage notes==		==Usage notes==
	<ul>		<ul>

Dme at 11:43, 8 February 2012

2012-02-08T11:43:50Z

← Older revision		Revision as of 11:43, 8 February 2012
Line 1:		Line 1:
	{{Template:Recordset:RemoveRecordsetNew subtitle}}		{{Template:Recordset:RemoveRecordsetNew subtitle}}

	<var>RemoveRecordsetNew</var> ~~&amp;ldquo;NOTs&amp;rdquo;~~ a <var>Recordset</var> object's records ~~with~~ the records		<var>RemoveRecordsetNew</var> "subtracts", from a <var>Recordset</var> object's records, the records
	in ~~an existing~~ <var>Recordset</var> object ~~and produces~~ a new <var>Recordset</var> object that		in a second <var>Recordset</var> object, producing a new <var>Recordset</var> object that
	contains all the records in the first <var>Recordset</var>, but not the second.		contains all the records in the first <var>Recordset</var>, but not the second. It does the same processing as <var>[[RemoveRecordset (Recordset subroutine)\|RemoveRecordset]]</var>, but it produces a new output <var>Recordset</var> and leaves the two input <var>Recordset</var>s unmodified.
	~~That is~~, it ~~removes records from the method~~ <var>Recordset</var> ~~object~~
	~~that are in~~ the input <var>Recordset</var> ~~object~~.
	==Syntax==		==Syntax==
	{{Template:Recordset:RemoveRecordsetNew syntax}}		{{Template:Recordset:RemoveRecordsetNew syntax}}
	===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''~~ and ~~''%rs''~~.		<td>A non-null <var>Recordset</var> object, which must have the same file context as <var class="term">%outRecordset</var> and the method object <var class="term">recordset</var>.
	</td></tr></table>		</td></tr></table>
	==Usage notes==		==Usage notes==
Line 23:		Line 21:
	<li>The <var>RemoveRecordsetNew</var> method is only available in <var class="product">Sirius Mods</var> 7.1 and later.		<li>The <var>RemoveRecordsetNew</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 <var>Recordset</var> object is		<li>The <var>LockStrength</var> and <var>LoopLockStrength</var> of the output <var>Recordset</var> 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>RemoveRecordsetNew</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>RemoveRecordsetNew</var> never adds records to a <var>Recordset</var>, there are no lock		<li>Since <var>RemoveRecordsetNew</var> never adds records to a <var>Recordset</var>, there are no lock

Dme: /* See also */

2012-02-07T19:42:42Z

Dme: /* Examples */

2012-02-07T19:41:39Z

Examples

← Older revision		Revision as of 19:41, 7 February 2012
Line 47:		Line 47:
	%threaten = %arrears:removeRecordset(%bigCust)		%threaten = %arrears:removeRecordset(%bigCust)
	</p>		</p>
	<li><var>RemoveRecordsetNew</var> can be thought of as ~~a NOT operation~~,		<li><var>RemoveRecordsetNew</var> can be thought of as subtraction,
	<var>[[AddRecordsetNew (Recordset function)\|AddRecordsetNew]]</var> as an		<var>[[AddRecordsetNew (Recordset function)\|AddRecordsetNew]]</var> as an
	OR, and <var>[[AndRecordsetNew (Recordset function)\|AndRecordsetNew]]</var> as an AND.		OR, and <var>[[AndRecordsetNew (Recordset function)\|AndRecordsetNew]]</var> as an AND.
Line 66:		Line 66:
	and <code>%second</code>.		and <code>%second</code>.
	</ul>		</ul>

	==See also==		==See also==
	{{Template:Recordset:RemoveRecordsetNew footer}}		{{Template:Recordset:RemoveRecordsetNew footer}}

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:
			{{Template:Recordset:RemoveRecordsetNew subtitle}}

	~~<span class="pageSubtitle"><section begin=dpl_desc/><section end=dpl_desc/></span>~~		<var>RemoveRecordsetNew</var> &amp;ldquo;NOTs&amp;rdquo; a <var>Recordset</var> object's records with the records
	~~[[Category:Recordset methods\|RemoveRecordsetNew function]]~~
	~~<p>~~
	~~<var>RemoveRecordsetNew</var> is a member of the <var>[[Recordset class\|Recordset]]</var> class.~~
	~~</p>~~

	<var>RemoveRecordsetNew</var> &ldquo;NOTs&rdquo; a <var>Recordset</var> object's records with the records
	in an existing <var>Recordset</var> object and produces a new <var>Recordset</var> object that		in an existing <var>Recordset</var> object and produces a new <var>Recordset</var> object that
	contains all the records in the first <var>Recordset</var>, but not the second.		contains all the records in the first <var>Recordset</var>, but not the second.
Line 12:		Line 7:
	that are in the input <var>Recordset</var> object.		that are in the input <var>Recordset</var> object.
	==Syntax==		==Syntax==
	~~<p class="syntax">%target = %rs~~:RemoveRecordsetNew~~(recordsetObject)~~		{{Template:Recordset:RemoveRecordsetNew syntax}}
	~~</p>~~
	===Syntax terms===		===Syntax terms===
	<table class="syntaxTable">		<table class="syntaxTable">
Line 25:		Line 19:
	<td>A non-null <var>Recordset</var> object, which must have the same file context as ''%target'' and ''%rs''.		<td>A non-null <var>Recordset</var> object, which must have the same file context as ''%target'' and ''%rs''.
	</td></tr></table>		</td></tr></table>
	==Usage ~~Notes~~==		==Usage notes==
	<ul>		<ul>
	<li>The <var>RemoveRecordsetNew</var> method is only available in <var class="product">Sirius Mods</var> 7.1 and later.		<li>The <var>RemoveRecordsetNew</var> method is only available in <var class="product">Sirius Mods</var> 7.1 and later.
Line 72:		Line 66:
	and <code>%second</code>.		and <code>%second</code>.
	</ul>		</ul>
			==See also==
			{{Template:Recordset:RemoveRecordsetNew footer}}

JALWiccan: 1 revision

2011-04-13T17:21:30Z

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 6:		Line 6:
	</p>		</p>

	<var>RemoveRecordsetNew</var> “NOTs” a <var>Recordset</var> object's records with the records		<var>RemoveRecordsetNew</var> &ldquo;NOTs&rdquo; a <var>Recordset</var> object's records with the records
	in an existing <var>Recordset</var> object and produces a new <var>Recordset</var> object that		in an existing <var>Recordset</var> object and produces a new <var>Recordset</var> object that
	contains all the records in the first <var>Recordset</var>, but not the second.		contains all the records in the first <var>Recordset</var>, but not the second.
Line 14:		Line 14:
	<p class="syntax">%target = %rs:RemoveRecordsetNew(recordsetObject)		<p class="syntax">%target = %rs:RemoveRecordsetNew(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:42, 7 February 2012
Line 68:		Line 68:

	==See also==		==See also==
			<ul>
			<li><var>[[RemoveRecordset (Recordset subroutine)\|RemoveRecordset]]</var>
			</ul>
	{{Template:Recordset:RemoveRecordsetNew footer}}		{{Template:Recordset:RemoveRecordsetNew footer}}