Zoomed Image

AMSX Scripting Language - Command : SqlStatement.CreateFromQuery

Summary

Build a SQL statement variable from a saved xAssets query definition

Description

Creates a new SqlStatement AMSX variable by loading and compiling the named saved query. The resulting variable can then be modified with other SqlStatement commands before execution. Must be used with a Set assignment so the variable is stored.

Parameters

ParameterDescription
cmdsaved query name
Argument 0not used
Argument 1search filter string to apply to the query (SearchFor)

Syntax


SqlStatement.CreateFromQuery "saved query name", "not used", "search filter string to apply to the query (SearchFor)"

Return to the AMSX Command Reference