Lasso Soft Inc. > Home

[ SkipRecords_Value ]

Method

[SkipRecords_Value] returns the current offset into a found set.

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

  • Syntax
SkipRecords_Value
Examples
  • Beginner

To return the current offset into the found set of a database search:

Use the [SkipRecords_Value] method. The following [Inline] method performs a search in the People table of the Contacts database for all records and return the offset into the records that were found.

Code

inline(
	-Database='Contacts',
	-SQL='SELECT * FROM People',
	-MaxRecords=5,
	-SkipRecords=5
	) => {^
	'Showing records starting at record number '+SkipRecords_Value+'...'
^}

Result

Showing records starting at record number 5...

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