IsEmpty (Recordset function): Difference between revisions
Jump to navigation
Jump to search
m (moved IsEmpty (Recordset property) to IsEmpty (Recordset function)) |
m (moved IsEmpty (Recordset property) to IsEmpty (Recordset function)) |
||
| Line 1: | Line 1: | ||
{{Template:Recordset:IsEmpty subtitle}} | |||
This property returns a | This property returns a | ||
| Line 9: | Line 5: | ||
set is empty (has no records) and <var>False</var> if the set has records. | set is empty (has no records) and <var>False</var> if the set has records. | ||
==Syntax== | ==Syntax== | ||
{{Template:Recordset:IsEmpty syntax}} | |||
===Syntax terms=== | |||
===Syntax | |||
<table class="syntaxTable"> | <table class="syntaxTable"> | ||
<tr><th>%bool</th> | <tr><th>%bool</th> | ||
| Line 26: | Line 21: | ||
Use <var>[[Count (Recordset function)|Count]]</var> only | Use <var>[[Count (Recordset function)|Count]]</var> only | ||
when you need the number of records. | when you need the number of records. | ||
==See also== | |||
{{Template:Recordset:IsEmpty footer}} | |||
Revision as of 19:33, 15 April 2011
Is Recordset empty? (Recordset class)
This property 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
| %bool | A declared enumeration object of type Boolean to contain the returned value of IsEmpty. |
|---|---|
| %recSet | An instantiated Recordset object variable. |
Usage Note
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.