Skip to main content

Examining the Current Row of the Result Set

Examining the Current Row of the Result Set

Use the following methods to examine the current row of the result set:

Get()
method Get(pName As %String) returns %String

Returns the value of the column that has the name pName, in the current row.

GetData()
method GetData(pColumn As %Integer) returns %String 

Returns the value of the column whose position is specified by pColumn in the current row.

GetColumnName()
method GetColumnName(pColumn As %Integer = 0)

Returns the name of the column whose position is specified by pColumn.

Note:

If the source data contains any unnamed columns, the result set automatically provides names for these columns in the following form: xCol_n

FeedbackOpens in a new tab