[Total_Records]
[Total_Records] returns the total number of records in the current table.
This tag can be used within the [Inline] ... [/Inline] tags that perform a database action or in a format file which is the response to an HTML form or URL that performs a database action. This tag cannot be used within [Records] ... [/Records] tags that reference a named inline.
- Syntax
- Parameters
[Total_Records]Examples
To return the total number of records found by a database search:
Use the [Total_Records] tag. The following [Inline] ... [/Inline] tags perform a search in the People table of the Contacts database for all records and return the total number of records in the database table.
[Inline: -FindAll,
-Database='Contacts',
-Table='People',
-KeyField='ID',
-MaxRecords=1]
<br>The are [Total_Records] records in the table.
[/Inline]Result:
<br>There are 6 records in the table.
| Tag Link | [Total_Records] | Category | Results |
|---|---|---|---|
| Type | Substitution | Data Source | FMP |
| Support | Preferred | Version | 2.5 |
| Output Type | Integer | Security | None |
| Implementation | LCAPI | Sets | Lasso 7.0, Lasso 6.0, Lasso 5.0,LDML3x,LDML25 |
Please note that periodically LassoSoft will go through the notes and may incorporate information from them into the documentation. Any submission here gives LassoSoft a non-exclusive license and will be made available in various formats to the Lasso community.
LassoSoft Inc. > Home
©LassoSoft Inc 2015 | Web Development by Treefrog Inc | Privacy | Legal terms and Shipping | Contact LassoSoft