Value Extractor Functoid

 

Use the Value Extractor functoid ( ) to extract the value from a specified column in a Microsoft ActiveX Data Objects (ADO) recordset, which is returned by the Database Lookup functoid.

Input

Parameter 1: An ADO recordset, which is the output of the Database Lookup functoid. This recordset never contains more than one database row.

Parameter 2: The name of a column from which to extract a value for output.

Output

Output 1: A value from the specified column in the single-row ADO recordset that was retrieved by using the Database Lookup functoid.

Remarks

To avoid errors that are only detected at run time, make sure that the first parameter to the Value Extractor functoid is the output of a Database Lookup functoid and not the output of any other functoid in the Databasecategory or custom functoid that returns an ADO recordset.

See Also

Database Functoids Reference
Database Functoids
How to Add Basic Functoids to a Map
Database Lookup Functoid
Error Return Functoid