Lasso Soft Inc. > Home

[ Shown_First ]

Method

[Shown_First] returns the number of the first record shown from the found set. Usually the same value as [SkipRecords_Value].

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

  • Syntax
Shown_First
Examples
  • Beginner

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

Use the [Shown_First] method. The following [Inline] method perform a search in the People table of the Contacts database for all records and returns the index of the first record found.

Code

inline(
	-Database='Contacts',
	-SQL='SELECT * FROM People',
	-MaxRecords=5
	) => {^
	'Showing '+Shown_First+' to '+Shown_Last+' records.'
^}

Result

Showing 1 to 5 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