<@ACTIONRESULT>

Syntax

<@ACTIONRESULT NAME=actionName NUM=itemNumber [FORMAT=format] [ENCODING=encoding]>

Description

Returns the value of the specified item from the first row of results generated by an action in the current execution.

Use this meta tag inside any action to reference data from the first row of a previously executed results generating action, such as a Search, External, or Direct DBMS action. The NAME attribute refers to the name of the action that generated the result during the current execution of the application file. The NUM attribute is the number of the column to get (for example, to get the value of the third column in the first row returned by an action, specify NUM=3).

Note: When the action result being asked for has been executed multiple times, as can occur if the action is inside a loop, the value from the last execution of the action is returned. When the action name specified is ambiguous, as can occur when branching to another application file, the <@ACTIONRESULT> tag refers to the last one executed.

Note: For FileMaker Pro data sources (Mac OS), Insert actions return a single item of data--the record ID of the newly created record--that may be accessed by <@ACTIONRESULT InsertActionName 1>.

Example

Your new account number is:
<B><@ACTIONRESULT NAME="GetUniqueID" NUM="1"></B>.

In this example, <@ACTIONRESULT> evaluates to the first item from the first row of the result set generated by the action GetUniqueID.

See Also

<@COL>
<@COLUMN>
Encoding Attribute
<@FORMAT>
Format Attribute
<@PURGERESULTS>
<@RESULTS>