<@COLUMN>

Syntax

<@COLUMN NAME=name [FORMAT=format] [ENCODING=encoding]>

Description

Returns the value of the named column in the current row of a <@ROWS> block. The name can be in column, table.column or owner.table.column format, as long as it is not ambiguous.

Note: For FileMaker Pro data sources (Mac OS), the name may be in field or layout.field format.

If the tag cannot be evaluated due to insufficient information (ambiguity) or a mismatch for all the columns, a blank is returned.

This tag is supported for Direct DBMS actions only when ODBC data sources are used.

Example

<@ROWS>
<@COLUMN NAME=TEST.TEST_TABLE_A.KEY_FIELD>,
<@COLUMN NAME=TEST.TEST_TABLE_A.CHAR_FIELD>,
<@COLUMN NAME=INT_FIELD>
<BR>
</@ROWS>

This example goes through every row in the results set and returns the values of the named columns in each row.

See Also

<@COL>
<@COLS> </@COLS>
<@CURCOL>
Encoding Attribute
Format Attribute