Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help VBA SQLXL SQL Statements

Buy now

Download now

SQL*XL online help

 

SQL*XL API: Statements Property

Statements Property

SQL*XL
home
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

SQL*XL ribbon in Excel