Zoomed Image

AMSX Scripting Language - Command : sqlstatement.addapifield

Summary

Add an API-expression field to a SQL statement variable

Description

Adds a named field sourced from an API expression to the field list of the given SQL statement variable. Use this when building dynamic queries that need to incorporate API-resolved values as select fields.

Parameters

ParameterDescription
cmdSQL statement variable name
Argument 0field name to add
Argument 1API expression that resolves the field value

Syntax


SqlStatement.AddAPIFIeld "SQL statement variable name", "field name to add", "API expression that resolves the field value"

Return to the AMSX Command Reference