IView.SQLText

Syntax

SQLText(Driver: String): String;

Parameters

Driver. DBMS driver identifier.

Description

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

Comments

The list of identifiers that can be used as a value of the Driver parameter is given in the Summary List of Identifiers section.

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.