[Shown_Count] returns the number of records shown in the current found set. Usually the same value as [MaxRecords_Value].
This method can be used within the [Inline] code block 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 method cannot be used within [Records] code blocks that reference a named inline.
Shown_Count
Use the [Shown_Count] method. The following [Inline] code block performs a search in the People table of the Contacts database for all records and returns how many records are currently being shown.
Code
inline(
-Database='Contacts',
-SQL='SELECT * FROM People',
-MaxRecords=5
) => {^
'Showing '+Shown_Count+' records.'
^}
Result
Showing 7 records.
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 2015 | Web Development by Treefrog Inc | Privacy | Legal terms and Shipping | Contact LassoSoft
Recent Comments