[TOC] [Prev] [Next] [Bottom]

<@COLUMN>

Syntax

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

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. This meta tag is only valid for Search and Direct DBMS actions.

Outside of a <@ROWS> block, this meta tag returns the value of the named column for the first row of the current result set.

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

[TOC] [Prev] [Next] [Bottom]

Copyright © 1999, Pervasive Software. All rights reserved.