Lasso Soft Inc. > Home

[ Shown_Last ]

Method

[Shown_Last] returns the number of the last record shown from the found set.

This method can be used within the [Inline] code block that performs a database action. This method cannot be used within [Records] code blocks that reference a named inline.

  • Syntax
Shown_Last
Examples
  • Beginner

To return the number of the last record found by a database search:

Use the [Shown_Last] method. The following [Inline] code block performs a search in the People table of the Contacts database for all records and returns the index of the last record found.

Code

inline(
	-Database='Contacts',
	-SQL='SELECT * FROM People',
	-MaxRecords=5
	) => {^
	'Showing '+Shown_First+' to '+Shown_Last+' 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 2014 | Web Development by Treefrog Inc | PrivacyLegal terms and Shipping | Contact LassoSoft