SQL

Class: TMMScript

property SQL : TStrings;

SQL text to upload and execute.
Multi-statement scripts are supported.
Only the result set of the last statement is returned.

Assign via SQL.Text at runtime:

Script.SQL.Text := 'SELECT id, name FROM orders WHERE status = ''pending''';

Multi-line scripts can be assigned in the same way — Delphi string concatenation works naturally with SQL.Text:

Script.SQL.Text :=
  'SELECT product_id, SUM(qty_sold) AS total_sold ' +
  'FROM daily_sales ' +
  'WHERE sale_date >= ''2026-01-01'' ' +
  'GROUP BY product_id';

At design time the Object Inspector shows a memo editor button for SQL, allowing multi-line SQL to be entered directly in the IDE.

Note: SQL is a TStrings object owned by TMMScript.
Do not free or replace it — assign only via SQL.Text := ... or SQL.Assign(AStrings).

SQL

See Also