Value Extractor Functoid
Use the Value Extractor functoid ( .jpeg)
) 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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for