A script-enabled browser is required for this page to function properly.

SRW.GH_GET_VALUE built-in function

This function retrieves the value of column columnName from the group cursor GC and does an implicit conversion to the output type required.

This function can also retrieve the value of the column columnName from the group cursor GC and do a conversion to VARCHAR using the provided format mask, formatMask, which is ignored if the column datatype already CHARACTER.

Syntax


SRW.GH_GET_VALUE ( CURSOR IN SRW.CURSOR, columnNameIN VARCHAR, VAL OUT type)

SRW.GH_GET_VALUE ( CURSOR IN SRW.CURSOR, columnNameIN VARCHAR, fromatMaskIN VARCHAR, VAL OUT VARCHAR)

Parameters

Description

columnName

Any valid column name.

type

Types supported include NUMBER, DATE, VARCHAR.

 

Exception

Description

COLUMN_NOT_FOUND

Column name does not exist in the cursor, or the given position is greater than the number of columns.

Example

See SRW.GH_CREATE built-in function

See also

SRW.GH_CREATE built-in function

SRW.GH_NEXT built-in function

About the Reports Builder built-in package (SRW)

SRW built-in package