Zoomed Image

AMSX Scripting Language - Command : SqlSet

Summary

Execute a SQL statement and assign its columns to named variables

Description

Runs a SQL statement, reads the first row of the result, and assigns each column value to the corresponding variable name. Columns are matched to variable names by position. Variables are created or updated in the variable collection.

Parameters

ParameterDescription
cmdComma-separated list of variable names (matched to result columns left to right)
Argument 0SQL statement to execute

Syntax


SqlSet "Comma-separated list of variable names (matched to result columns left to right)", "SQL statement to execute"

Return to the AMSX Command Reference