RemoveRecordset (Recordset subroutine) - Revision history

JAL: /* Examples */

2012-11-06T23:51:10Z

Examples

← Older revision		Revision as of 23:51, 6 November 2012
Line 25:		Line 25:

	==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>.
Line 62:		Line 62:
	And <code>%first</code> is now the exclusive OR of the original <code>%first</code>		And <code>%first</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==

JAL at 23:50, 6 November 2012

2012-11-06T23:50:43Z

← Older revision		Revision as of 23:50, 6 November 2012
Line 1:		Line 1:
	{{Template:Recordset:RemoveRecordset subtitle}}		{{Template:Recordset:RemoveRecordset subtitle}}

	<var>RemoveRecordset</var> removes or "subtracts", from the method <var>Recordset</var> object's records, the records		<var>RemoveRecordset</var> removes or "subtracts," from the method <var>Recordset</var> object's records, the records
	in a second		in a second <var>Recordset</var> object.
	<var>Recordset</var> object
	==Syntax==		==Syntax==
	{{Template:Recordset:RemoveRecordset syntax}}		{{Template:Recordset:RemoveRecordset syntax}}

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

	~~</td></tr></table>~~
	==Usage notes==		==Usage notes==
	<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>RemoveRecordset</var> never adds records to a <var>Recordset</var>, there are no lock		<li>Since <var>RemoveRecordset</var> never adds records to a <var>Recordset</var>, there are no lock
	strength requirements for the method object or the input object.		strength requirements for the method object or the input object.
	</ul>		</ul>

	==Examples==		==Examples==
	<ul>		<ul>
	<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"> %threaten is object recordSet in file orders		<p class="code">%threaten is object recordSet in file orders
	%bigCust is object recordSet in file orders		%bigCust is object recordSet in file orders

	find records to %threaten		find records to %threaten
	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:removeRecordset(%bigCust)		%threaten:removeRecordset(%bigCust)
	</p>		</p>

	<li><var>RemoveRecordset</var> can be thought of as subtraction,		<li><var>RemoveRecordset</var> can be thought of as subtraction,
	<var>[[AddRecordset (Recordset subroutine)\|AddRecordset]]</var> as an		<var>[[AddRecordset (Recordset subroutine)\|AddRecordset]]</var> as an
Line 47:		Line 51:
	However, you can achieve an exclusive OR operation with the		However, you can achieve 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
	%both is object recordSet in foo		%both is object recordSet in foo
	...		...
	%both = %first:copy		%both = %first:copy
	%both:andRecordset(%second)		%both:andRecordset(%second)
	%first:addRecordset(%second)		%first:addRecordset(%second)
	%first:removeRecordset(%both)		%first:removeRecordset(%both)
	</p>		</p>
	And <code>%first</code> is now the exclusive OR of the original <code>%first</code>		And <code>%first</code> is now the exclusive OR of the original <code>%first</code>

Dme at 19:34, 8 February 2012

2012-02-08T19:34:13Z

← Older revision		Revision as of 19:34, 8 February 2012
Line 1:		Line 1:
	{{Template:Recordset:RemoveRecordset subtitle}}		{{Template:Recordset:RemoveRecordset subtitle}}

	<var>RemoveRecordset</var> ~~&amp;ldquo;NOTs&amp;rdquo; a~~ <var>Recordset</var> object's records ~~with~~ the records		<var>RemoveRecordset</var> removes or "subtracts", from the method <var>Recordset</var> object's records, the records
	in ~~an existing~~		in a second
	<var>Recordset</var> object~~: that is, it removes records from the method <var>Recordset</var> object~~		<var>Recordset</var> object
	~~that are in the input <var>Recordset</var> object.~~
	==Syntax==		==Syntax==
	{{Template:Recordset:RemoveRecordset syntax}}		{{Template:Recordset:RemoveRecordset 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.
	</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 <~~code~~>~~%target~~</~~code~~>.		<td>A non-null <var>Recordset</var> object, which must have the same file context as <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>RemoveRecordset</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>RemoveRecordset</var> never adds records to a <var>Recordset</var>, there are no lock		<li>Since <var>RemoveRecordset</var> never adds records to a <var>Recordset</var>, there are no lock
	strength requirements for the method object or the input object.		strength requirements for the method object or the input object.
Line 47:		Line 45:
	be rarely needed.		be rarely needed.

	However, you can achieve ~~such~~ an exclusive OR operation with the		However, you can achieve 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

Dme: /* Examples */

2012-02-07T19:43:35Z

Examples

← Older revision		Revision as of 19:43, 7 February 2012
Line 40:		Line 40:
	%threaten:removeRecordset(%bigCust)		%threaten:removeRecordset(%bigCust)
	</p>		</p>
	<li><var>RemoveRecordset</var> can be thought of as ~~a NOT operation~~,		<li><var>RemoveRecordset</var> can be thought of as subtraction,
	<var>[[AddRecordset (Recordset subroutine)\|AddRecordset]]</var> as an		<var>[[AddRecordset (Recordset subroutine)\|AddRecordset]]</var> as an
	OR, and <var>[[AndRecordset (Recordset subroutine)\|AndRecordset]]</var> as an AND.		OR, and <var>[[AndRecordset (Recordset subroutine)\|AndRecordset]]</var> as an AND.
Line 61:		Line 61:
	and <code>%second</code>.		and <code>%second</code>.
	</ul>		</ul>

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

Dme: /* See also */

2012-02-07T19:43:13Z

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:RemoveRecordset subtitle}}

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

	<var>RemoveRecordset</var> &ldquo;NOTs&rdquo; a <var>Recordset</var> object's records with the records
	in an existing		in an existing
	<var>Recordset</var> object: that is, it removes records from the method <var>Recordset</var> object		<var>Recordset</var> object: that is, it removes records from the method <var>Recordset</var> object
	that are in the input <var>Recordset</var> object.		that are in the input <var>Recordset</var> object.
	==Syntax==		==Syntax==
	~~<p class="syntax">%target~~:RemoveRecordset~~(recordsetObject)~~		{{Template:Recordset:RemoveRecordset syntax}}
	~~</p>~~
	===Syntax terms===		===Syntax terms===
	<table class="syntaxTable">		<table class="syntaxTable">
Line 22:		Line 16:

	</td></tr></table>		</td></tr></table>
	==Usage ~~Notes~~==		==Usage notes==
	<ul>		<ul>
	<li>If the <var>Recordset</var> object argument of <var>RemoveRecordset</var> is null, the request is		<li>If the <var>Recordset</var> object argument of <var>RemoveRecordset</var> is null, the request is
Line 67:		Line 61:
	and <code>%second</code>.		and <code>%second</code>.
	</ul>		</ul>
			==See also==
			{{Template:Recordset:RemoveRecordset 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>RemoveRecordset</var> “NOTs” a <var>Recordset</var> object's records with the records		<var>RemoveRecordset</var> &ldquo;NOTs&rdquo; a <var>Recordset</var> object's records with the records
	in an existing		in an existing
	<var>Recordset</var> object: that is, it removes records from the method <var>Recordset</var> object		<var>Recordset</var> object: that is, it removes records from the method <var>Recordset</var> object
Line 13:		Line 13:
	<p class="syntax">%target:RemoveRecordset(recordsetObject)		<p class="syntax">%target:RemoveRecordset(recordsetObject)
	</p>		</p>
	===Syntax ~~Terms~~===		===Syntax terms===
	<table class="syntaxTable">		<table class="syntaxTable">
	<tr><th>%target</th>		<tr><th>%target</th>

Admin: 1 revision

2011-04-12T19:30:46Z

1 revision

← Older revision	Revision as of 19:30, 12 April 2011
(No difference)