IView.SQLText

Syntax

SQLText(Driver: String): String;

Parameters

Driver. DBMS driver identifier. The summary list of identifiers that can be specified as a parameter value is given in the Supported DBMS subsection.

Description

The SQLText property determines SQL query of view for the certain driver of database.

Example

Sub Main;
Var
    MB: IMetabase;
    Predstav: IView;
    SQL: String;
Begin
    MB := MetabaseClass.Active;
    Predstav := MB.ItemById("View_1").Bind As IView;
    SQL := Predstav.SqlText("ORCL");
End Sub Main;

After executing the example, the SQL variable contains SQL query for Oracle driver. The view has the View_1 identifier.