Zoomed Image

AMSX Scripting Language - Command : sqlstatement.addwhereclause

Summary

Add a WHERE condition to a SQL statement variable

Description

Appends a WHERE condition to the given SQL statement variable. Multiple conditions are combined using the specified AND/OR connector.

Parameters

ParameterDescription
cmdSQL statement variable name
Argument 0WHERE condition expression
Argument 1connector to use with existing conditions (AND or OR, default AND)

Syntax


SqlStatement.AddWhereClause "SQL statement variable name", "WHERE condition expression", "connector to use with existing conditions (AND or OR, default AND)"

Return to the AMSX Command Reference