Cursor (Recordset function) - Revision history

Dme: /* Syntax terms */

2012-02-07T19:54:52Z

Syntax terms

Dme: /* Syntax terms */

2012-02-07T19:54:18Z

Syntax terms

Dme at 19:51, 7 February 2012

2012-02-07T19:51:34Z

JAL2 at 19:43, 15 April 2011

2011-04-15T19:43:26Z

JALWiccan: 1 revision

2011-04-15T19:33:20Z

1 revision

JAL2: Created page with "
Cursor constructor
`Cursor` is a member of the
2011-04-15T19:33:19Z

Created page with "<span class="pageSubtitle"><section begin=dpl_desc/><section end=dpl_desc/></span> Cursor constructor <p> <var>Cursor</var> is a member of the <var..."

← Older revision Revision as of 19:33, 15 April 2011
Line 1: Line 1:

<span class="pageSubtitle"><section begin=dpl_desc/><section end=dpl_desc/></span>
{{Template:Recordset:Cursor subtitle}}

[[Category:Recordset methods|Cursor constructor]]

<p>

<var>Cursor</var> is a member of the <var>[[Recordset class|Recordset]]</var> class.

</p>

Instantiates a <var>[[RecordsetCursor class|RecordSetCursor]]</var> object for a
Instantiates a <var>[[RecordsetCursor class|RecordSetCursor]]</var> object for a

particular instance of a <var>Recordset</var> object.
particular instance of a <var>Recordset</var> object.

==Syntax==
==Syntax==

<p class="syntax">%rscursor = %rs:Cursor([LoopLockStrength=lockstrength])
{{Template:Recordset:Cursor syntax}}

</p>
===Syntax terms===

===Syntax Terms===

<table class="syntaxTable">
<table class="syntaxTable">

<tr><th>%rscursor</th>
<tr><th>%rscursor</th>

Line 22: Line 17:

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

==Usage Notes==
==Usage notes==

<ul>
<ul>

<li>You can have as many cursors as you want for a record set.
<li>You can have as many cursors as you want for a record set.

Line 30: Line 25:

positioned on the first record in the set.
positioned on the first record in the set.

</ul>
</ul>

==See also==

{{Template:Recordset:Cursor footer}}

JAL2: Created page with "
Cursor constructor
`Cursor` is a member of the
2011-04-15T17:22:13Z

Created page with "<span class="pageSubtitle"><section begin=dpl_desc/><section end=dpl_desc/></span> Cursor constructor <p> <var>Cursor</var> is a member of the <var..."

New page
<span class="pageSubtitle"><section begin=dpl_desc/><section end=dpl_desc/></span>
[[Category:Recordset methods|Cursor constructor]]
<p>
<var>Cursor</var> is a member of the <var>[[Recordset class|Recordset]]</var> class.
</p>

Instantiates a <var>[[RecordsetCursor class|RecordSetCursor]]</var> object for a
particular instance of a <var>Recordset</var> object.
==Syntax==
<p class="syntax">%rscursor = %rs:Cursor([LoopLockStrength=lockstrength])
</p>
===Syntax Terms===
<table class="syntaxTable">
<tr><th>%rscursor</th>
<td>A declared <var>RecordsetCursor</var> object, to which <var>Cursor</var> returns an instance of a <var>RecordsetCursor</var> object, if ''%rs'' has at least one record. If ''%rs'' has no records, <var>Cursor</var> returns a <var>Null</var> object.
</td></tr>
<tr><th>%rs</th>
<td>A reference to an instance of a <var>Recordset</var> object.
</td></tr>
<tr><th><b>LoopLockStrength=</b>lockstrength</th>
<td>The lock strength to be used for <var>For Record At</var> loops on the cursor. This is an optional, [[Notation conventions for methods#Named parameters|name required]], parameter, available in <var class="product">Sirius Mods</var> 7.0 and later. It defaults to <var>None</var>. See [[RecordsetCursor#LoopLockStrength for RecordsetCursors|"LoopLockStrength for RecordsetCursors"]].

</td></tr></table>
==Usage Notes==
<ul>
<li>You can have as many cursors as you want for a record set.
<li>To test for an empty record set, use <var>[[IsEmpty (Recordset property)|IsEmpty]]</var>, which
is much more efficient than testing the record <var>Count</var> for 0,
<li>The instantiated <var>RecordsetCursor</var> is automatically
positioned on the first record in the set.
</ul>