AddRecordsetNew (Recordset function) - Revision history

JAL: /* Example */

2012-11-06T22:20:24Z

Example

← Older revision		Revision as of 22:20, 6 November 2012
Line 62:		Line 62:
	In the following example, the result of one <var>Find</var> is combined with the		In the following example, the result of one <var>Find</var> is combined with the
	result of another:		result of another:
	<p class="code"> %review is object recordSet in file orders		<p class="code">%review is object recordSet in file orders
	%pending is object recordSet in file orders		%pending is object recordSet in file orders
	%both is object recordSet in file orders		%both 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 %pending		find records to %pending
	status = 'PENDING'		status = 'PENDING'
	end find		end find

	%both = %review:addRecordsetNew(%pending)		%both = %review:addRecordsetNew(%pending)
	</p>		</p>
	Of course, identical processing could be done with an		Of course, identical processing could be done with an <var>Or</var> in a <var>Find</var> statement.
	<var>Or</var> in a <var>Find</var> statement.
	==See also==		==See also==
	<ul>		<ul>

JAL2: /* Usage notes */

2012-02-22T22:32:15Z

Usage notes

← Older revision		Revision as of 22:32, 22 February 2012
Line 55:		Line 55:
	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>

JAL2: /* Syntax terms */

2012-02-22T22:29:30Z

Syntax terms

← Older revision		Revision as of 22:29, 22 February 2012
Line 14:		Line 14:
	</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>inRecordset2</th>		<tr><th>inRecordset2</th>
	<td>A non-null <var>Recordset</var> object, which must have the same file context as <var class="term">outRecordset</var> and <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 <var class="term">recordset</var>.

	</td></tr></table>		</td></tr></table>

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

Dme at 19:30, 7 February 2012

2012-02-07T19:30:18Z

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

	<var>AddRecordsetNew</var> ~~adds~~ a <var>Recordset</var> object's records to the records in ~~an existing~~		<var>AddRecordsetNew</var> combines a <var>Recordset</var> object's records with the records in a second
	<var>Recordset</var> object, ~~and produces~~ a new <var>Recordset</var> object containing the combined		<var>Recordset</var> object, producing a new <var>Recordset</var> object containing the combined
	records.		records.
	It does the same processing as <var>[[AddRecordset (Recordset subroutine)\|AddRecordset]]</var>		It does the same processing as <var>[[AddRecordset (Recordset subroutine)\|AddRecordset]]</var>
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>inRecordset2</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 <var class="term">recordset</var>.

	</td></tr></table>		</td></tr></table>
Line 23:		Line 23:
	<ul>		<ul>
	<li>The <var>AddRecordsetNew</var> method is only available in <var class="product">Sirius Mods</var> 7.1 and later.		<li>The <var>AddRecordsetNew</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 (<var class="term">%outRecordset</var>) is
	the same as that of the method object (~~%rs~~).		the same as that of the method object (<var class="term">recordset</var>).
	<li>The lock strength of ~~the~~ <var>~~Recordset~~</var> ~~object being added to the method object~~		<li>The lock strength of <var class="term">inRecordset2</var> must be greater than or equal to the lock strength of the method object <var class="term">recordset</var>.
	must be greater than or equal to the lock strength of the ~~set being added to~~.

	Consequently, <var>AddRecordset</var> will not require any new locks &~~amp;amp;~~mdash;		Consequently, <var>AddRecordset</var> will not require any new locks —
	~~any~~ records being ~~added~~ must already be locked by the user at an equal		all records being combined must already be locked by the user at an equal
	or greater strength than the ~~target~~.		or greater strength than lock strength of the resulting <var class="term">outRecordset</var>.
	Therefore, this method will never cause a record locking conflict.		Therefore, this method will never cause a record locking conflict.
	Within a <var>Recordset</var>, all records are always locked at the same strength (the		Within a <var>Recordset</var>, all records are always locked at the same strength (the
Line 38:		Line 37:
	Any violation of them results in request cancellation.		Any violation of them results in request cancellation.
	<ul>		<ul>
	<li>To a <var>~~Recordset~~</var> locked at exclusive level, you may ~~add~~ only records that are		<li>To a method object <var class="term">recordset</var> locked at exclusive level, you may combine only records that are
	locked at exclusive level.		locked at exclusive level.
	<li>To a <var>~~Recordset~~</var> locked at share level, you may ~~add~~ records		<li>To a method object <var class="term">recordset</var> locked at share level, you may combine records
	locked at exclusive level or share level.		locked at exclusive level or share level.
	<li>To an unlocked <var>~~Recordset~~</var> you may ~~add~~ records locked at any strength		<li>To an unlocked method object <var class="term">recordset</var> you may combine records locked at any strength
	(exclusive, share, none).		(exclusive, share, none).
	</ul>		</ul>
	<li>If the <var>~~Recordset~~</var> ~~object parameter~~ of <var>AddRecordset</var> is null, the request is		<li>If the <var class="term">inRecordset2</var> argument of <var>AddRecordset</var> is null, the request is
	cancelled.		cancelled.
	<li>The <var>AddRecordsetNew</var> method can be thought of as a <var>Recordset</var> OR operation;		<li>The <var>AddRecordsetNew</var> method can be thought of as a <var>Recordset</var> OR operation;
Line 54:		Line 53:

	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\|"RemoveRecordsetNew Examples"]]</var>.		in <var>[[RemoveRecordsetNew (Recordset function)#Examples\|"RemoveRecordsetNew Examples"]]</var>.
	</ul>		</ul>

Dme: /* Usage notes */

2012-02-07T19:05:05Z

Usage notes

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

	==Example==		==Example==

Dme at 19:04, 7 February 2012

2012-02-07T19:04:15Z

← Older revision		Revision as of 19:04, 7 February 2012
Line 51:		Line 51:
	can be thought of as an AND; and		can be thought of as an AND; and
	<var>[[RemoveRecordsetNew (Recordset function)\|RemoveRecordsetNew]]</var>		<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

Dme: /* See also */

2012-02-07T19:03:33Z

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

	<var>AddRecordsetNew</var> adds a <var>Recordset</var> object's records to the records in an existing		<var>AddRecordsetNew</var> adds a <var>Recordset</var> object's records to the records in an existing
Line 11:		Line 7:
	but produces a new output <var>Recordset</var> and leaves the two input <var>Recordsets</var> unmodified.		but produces a new output <var>Recordset</var> and leaves the two input <var>Recordsets</var> unmodified.
	==Syntax==		==Syntax==
	~~<p class="syntax">%target = %rs~~:AddRecordsetNew~~(recordsetObject)~~		{{Template:Recordset:AddRecordsetNew 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>AddRecordsetNew</var> method is only available in <var class="product">Sirius Mods</var> 7.1 and later.		<li>The <var>AddRecordsetNew</var> method is only available in <var class="product">Sirius Mods</var> 7.1 and later.
Line 33:		Line 28:
	must be greater than or equal to the lock strength of the set being added to.		must be greater than or equal to the lock strength of the set being added to.

	Consequently, <var>AddRecordset</var> will not require any new locks &mdash;		Consequently, <var>AddRecordset</var> will not require any new locks &amp;mdash;
	any records being added must already be locked by the user at an equal		any records being added must already be locked by the user at an equal
	or greater strength than the target.		or greater strength than the target.
Line 82:		Line 77:
	Of course, identical processing could be done with an		Of course, identical processing could be done with an
	<var>Or</var> in a <var>Find</var> statement.		<var>Or</var> in a <var>Find</var> statement.
			==See also==
			{{Template:Recordset:AddRecordsetNew 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:03, 7 February 2012
Line 78:		Line 78:
	<var>Or</var> in a <var>Find</var> statement.		<var>Or</var> in a <var>Find</var> statement.
	==See also==		==See also==
			<ul>
			<li><var>[[AddRecord (Recordset subroutine)\|AddRecord]]</var>
			<li><var>[[AddRecordset (Recordset subroutine)\|AddRecordset]]</var>
			</ul>
	{{Template:Recordset:AddRecordsetNew footer}}		{{Template:Recordset:AddRecordsetNew footer}}