AMSX Scripting Language - Command : SqlStatement.ClearFieldList

Summary

Remove all fields from the SELECT list of a SQL statement variable

Description

Clears all fields from the SELECT clause of the given SQL statement variable, leaving the FROM and WHERE clauses intact. Use this before calling SetFields to replace the field list entirely.

Parameters

Parameter	Description
cmd	SQL statement variable name

Syntax


SqlStatement.ClearFieldList "SQL statement variable name"

Return to the AMSX Command Reference