Zoomed Image

AMSX Scripting Language - Command : SqlStatement.AddBaseTableFields

Summary

Add all base table fields to a SQL statement variable's SELECT list

Description

Introspects the base table of the SQL statement variable and adds all matching fields to the field list. Optionally restrict to spec fields only or exclude calculated (non-updateable) fields.

Parameters

ParameterDescription
cmdSQL statement variable name
Argument 0true to only add spec fields
Argument 1true to only add updateable fields (excludes calculated fields)

Syntax


SqlStatement.AddBaseTableFields "SQL statement variable name", "true to only add spec fields", "true to only add updateable fields (excludes calculated fields)"

Return to the AMSX Command Reference