Zoomed Image

AMSX Scripting Language - Command : exists

Summary

Run a SQL statement and return 1 if a value was found, or 0 if no record exists

Description

Executes a SQL statement and checks whether the result is non-empty. Returns "1" in the result buffer if a non-null value was returned, "0" otherwise. Use for conditional branching based on record existence.

Parameters

ParameterDescription
cmdSQL statement to execute (should return a single value)

Syntax


Exists "SQL statement to execute (should return a single value)"

Return to the AMSX Command Reference