Execute

Class: TMMScript

procedure Execute;

Requires Connection and SQL to be set before calling.

Performs the complete upload–execute–materialise cycle:

1. Uploads SQL to the server in chunks, firing OnProgress after each.
2. Executes it on the MySQL/MariaDB server, optionally wrapped in a transaction when UseTransaction is True.
3. If the last statement produces rows, creates a local EDB temporary table and fills it with all rows.
4. Sets all result properties. Any previous result is dropped first.

All result properties are valid after Execute returns, regardless of success or failure.

See Also

• TMMScript
• API Reference