SQL*XL API: Statements Property

Statements Property

SQL
	Statements
		Statement

Description:

The Statements property of the SQL object contains the collection of statements. Use the SQL.StatementCount property to find the total number of statements in this collection. The statements are numbered 1 to StatementCount.

Example:

Initialise 2 SQL statements and print the individual statements from the Statements collection:

SQLXL.SQL.setText("select * from emp; select * from dept;")
For l = 1 to SQLXL.SQL.StatementCount
    'Print the SQL statement in a message box
    MsgBox SQLXL.SQL.Statements(l).Text
Next l