Zoomed Image

AMSX Scripting Language - Command : QueryCache

Summary

Cache a query result in a temporary table, running it only once per script execution

Description

Executes a named query and stores its result in the specified temporary table, but only if the query has not already been cached during this script run. Repeated calls with the same query name are silently skipped. Useful for shared reference data loaded once and reused across multiple steps.

Parameters

ParameterDescription
cmdQuery name (used as the cache key)
Argument 0Temporary table name to store the query results in

Syntax


QueryCache "Query name (used as the cache key)", "Temporary table name to store the query results in"

Return to the AMSX Command Reference