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