AMSX Scripting Language - Command : Sql

Summary

Execute a SQL statement and place the first value of the result in the result buffer

Description

Runs a SQL statement against the main database connection and stores the first column of the first row as the result. Use this for simple scalar queries or data modification statements where you only need a single return value.

Parameters

Syntax

Sql "SQL statement to execute"