AMSX Scripting Language - Command : SqlStatement

Summary

Build and execute dynamic SQL statements using a fluent sub-command API

Description

Provides a set of sub-commands for constructing parameterised SQL queries programmatically. Use SqlStatement (no sub-command) to create the variable, then FieldList, BaseTable, AddJoin, AddWhereClause, GroupBy, OrderBy, etc. to build the query, and Sql or SelectInto to execute it.

Parameters

This command does not require parameters.

Syntax

SqlStatement