Class: ResultSet
Description
This method positions the cursor at the next row of the result set. When the result set is created, the cursor is positioned before the first row. Use this method to position the cursor on the first row, and then subsequent rows.
Syntax
objectName.next()
Parameters
None
Returns
1 if more rows exist in the result set.
0 if the cursor is at the end of the result set.
When Became Available
Profile v6.4
Example
type ResultSet rs = Db.select("ACN,NAM,TAXID","CIF")
while rs.next() do {
set ACN = rs.getCol("ACN")
set NAM = rs.getCol("NAM")
set TAXID = rs.getCol("TAXID")
}