Skip Headers

Oracle® Objects for OLE Developer's Guide
10g Release 1 (10.1)

Part Number B10118-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

SQL Property

See Also
Example
Applies To

OraDynaset

OraSQLStmt

Description

Returns or sets the SQL statement used to create the specified dynaset or sqlstmt object. Not available at design time and read/write at run time.

Usage

SQL_statement = oradynaset.SQL

SQL_statement = orasqlstmt.SQL

oradynaset.SQL = SQL_statement

orasqlstmt.SQL = SQL_statement

Remarks

The first usage form returns the contents of the SQL statement buffer.

The second usage form sets the contents of the SQL statement buffer.

The SQL statement buffer initially contains the SQL statement used to create the dynaset or sqlstmt object. The contents of the SQL statement buffer are executed whenever the Refresh method is issued.

Data Type

String