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 form above returns the contents of the SQL statement buffer.

The second form above 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