IsEmpty (Recordset function): Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (fix "using boolean enumerations" link)
mNo edit summary
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
{{Template:Recordset:IsEmpty subtitle}}
{{Template:Recordset:IsEmpty subtitle}}
<var>IsEmpty</var> returns a [[Enumerations#Using_Boolean_enumerations|"Boolean Enumeration"]] whose value is <code>True</code> if the set is empty (has no records) and <code>False</code> if the set has records.
<var>IsEmpty</var> returns a <var>[[Enumerations#Using_Boolean_enumerations|Boolean Enumeration]]</var> whose value is <var>True</var> if the set is empty (has no records) and <var>False</var> if the set has records.


==Syntax==
==Syntax==
{{Template:Recordset:IsEmpty syntax}}
{{Template:Recordset:IsEmpty syntax}}
===Syntax terms===
===Syntax terms===
<table class="syntaxTable">
<table class="syntaxTable">
<tr><th>%boolean</th>
<tr><th>%boolean</th>
<td>A declared enumeration object of type <var>[[Enumerations#Using Boolean enumerations|Boolean]]</var> to contain the returned value of <var>IsEmpty</var>.</td></tr>
<td>A declared enumeration object of type <var>Boolean</var> to contain the returned value of <var>IsEmpty</var>.</td></tr>
 
<tr><th>recordset</th>
<tr><th>recordset</th>
<td>An instantiated <var>Recordset</var> object variable.
<td>An instantiated <var>Recordset</var> object variable.</td></tr>
</td></tr></table>
</table>


==Usage notes==
==Usage notes==
<ul><li> Since it is much more efficient than testing the record count for 0, use <var>IsEmpty</var> when you simply need to test for an empty set. Use <var>[[Count (Recordset function)|Count]]</var> only
<ul>
when you need the number of records.
<li> Since it is much more efficient than testing the record count for 0, use <var>IsEmpty</var> when you simply need to test for an empty set. Use <var>[[Count (Recordset function)|Count]]</var> only when you need the number of records.
</ul>
</ul>


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

Latest revision as of 23:40, 6 November 2012

Is Recordset empty? (Recordset class)

IsEmpty returns a Boolean Enumeration whose value is True if the set is empty (has no records) and False if the set has records.

Syntax

%boolean = recordset:IsEmpty

Syntax terms

%boolean A declared enumeration object of type Boolean to contain the returned value of IsEmpty.
recordset An instantiated Recordset object variable.

Usage notes

  • Since it is much more efficient than testing the record count for 0, use IsEmpty when you simply need to test for an empty set. Use Count only when you need the number of records.

See also