Lasso Soft Inc. > Home

[ shown_count ]

Method

[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.

  • Syntax
Shown_Count
Examples
  • Beginner

To return the number of records shown in the results of a database search:

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.

Recent Comments

No Comments found

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 | PrivacyLegal terms and Shipping | Contact LassoSoft