We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Execute a SQL statement variable and assign column values to named AMSX variables
Runs the SQL statement variable, reads one row from the result set, and assigns each column value to the corresponding variable from the comma-separated list. If there are fewer rows than the requested row index, no assignment is made.
| Parameter | Description |
|---|---|
| cmd | SQL statement variable name |
| Argument 0 | comma-separated list of AMSX variable names to receive column values in order |
| Argument 1 | zero-based row index to read, or leave blank for the first row |
SqlStatement.SqlSet "SQL statement variable name", "comma-separated list of AMSX variable names to receive column values in order", "zero-based row index to read, or leave blank for the first row"