Zoomed Image

AMSX Scripting Language - Command : test.exists

Summary

Assert that at least one row matching a WHERE condition exists in a table

Description

Queries the specified table with the given WHERE clause. If no matching row is found, throws an exception with the error message. In the error message, use $filter and $table as substitution tokens for the actual filter and table name.

Parameters

ParameterDescription
cmdtable name to query
Argument 0WHERE clause (without the WHERE keyword) that must match at least one row
Argument 1error message to raise if no match is found (supports $filter and $table tokens)

Syntax


Test.Exists "table name to query", "WHERE clause (without the WHERE keyword) that must match at least one row", "error message to raise if no match is found (supports $filter and $table tokens)"

Return to the AMSX Command Reference