Install Now
current-row - (database)
Contents
Description
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>. current-row must be within a run-query
loop, and it always refers to the most inner one.
Examples
Display row number before a line with first and last name for each employee:
run-query @mydb="select firstName, lastName from employee" output firstName, lastName
@Row #<<current-row>><br/>
print-out firstName
@,
print-out lastName
@<br/>
end-query
Name
current-row - (database)
Purpose
Get or print out the row number of a current row in the result-set of a query.
See Also
Database
begin-transactioncommit-transactioncurrent-rowdatabase-config-filedb-errormariadb-databasepostgresql-databaserollback-transactionrun-querysqlite-database See all documentation
$DATE $VERSION GOLF(2gg)
Syntax
current-row [ to <current row> ]
PNG Icons
Emojis