Class: ResultSet
Description
This method returns the current results row from a result set object. You can specify a delimiter to separate data values in the result set. The standard delimiter is a tab character.
Syntax
ResultSet.getRow(String delimiter, String columnDefs)
Parameters
|
delimiter |
A character to be used as the delimiter in the result set. The parameter serves as an implicit call to Row.setDelimiter(delimiter). |
|
columnDefs |
A comma-separated list of types and columnNames. The parameter serves as an implicit call to Row.setColumns(columnDefs). If this parameter is not supplied, then the columnNames (and their associated types) will be taken from the first parameter of the Db.select() call that created the result set. |
Returns
A Row object.
When Became Available
Profile v6.0
Example 1 -- Default Tab Delimiter
type String ACN,NAM,TAXID
type ResultSet rs = Db.select("ACN,NAM,TAXID","CIF")
while rs.next() do {
set data = rs.getRow()
set ACN = data.acn
set NAM = data.nam
set TAXID= data.taxid
}
Example 2 – Assigning a Delimiter
type String ACN,NAM,TAXID
type ResultSet rs=Db.select("ACN,NAM,TAXID","CIF")
while rs.next() do {
set data = rs.getRow(“|”)
set ACN = data.acn
set NAM = data.nam
set TAXID = data.taxid
}