Zoomed Image

AMSX Scripting Language - Command : executetexttodataset

Summary

Execute collected SQL and store the result as a dataset, optionally writing it to a file

Description

Runs the SQL accumulated between TEXT and ENDTEXT on the main connection and stores the result as the current dataset buffer. If a file path is provided, the dataset is also written to disk in binary format for later use by DatasetFileToTable.

Parameters

ParameterDescription
cmdFile path to write the dataset to; leave blank to only cache the dataset in memory
Argument 0Optional CSV list of table names to assign to each result set in the dataset

Syntax


ExecuteTextToDataset "File path to write the dataset to; leave blank to only cache the dataset in memory", "Optional CSV list of table names to assign to each result set in the dataset"

Return to the AMSX Command Reference