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.