Get or print out the row number of a current row in the result-set of a query.
current-row [ to [ define ] <current row> ]
Without "to" clause, current-row will print out the current row number. First row is numbered 1. With "to" clause, the row number is stored into variable <current row>, which is created if "define" is used. current-row must be within a run-query
loop, and it always refers to the most inner one.
Display row number before a line with first and last name for each employee:
run-query @mydb="select firstName, lastName from employee"
Copyright (c) 2022 DaSoftver LLC. Vely is a trademark of Dasoftver LLC. The software and information herein are provided "AS IS" and without any warranties or guarantees of any kind. Icons copyright Paweł Kuna licensed under MIT
. This web page is licensed under CC-BY-SA-4.0