Db > Db Assembly Interfaces > IQuery > IQuery.ClearSqlText

IQuery.ClearSqlText

Syntax

ClearSqlText;

Description

The ClearSqlText method clears query text of object query.

Example

Sub UserProc;
Var
    Mb: IMetabase;
    MObj: IMetabaseObject;
    Query: IQuery;
Begin
    Mb:=MetabaseClass.Active;
    MObj:=Mb.ItemById("Query").Edit;
    Query:=MObj As IQuery;
    Query.ClearSqlText;
    MObj.Save;
End Sub UserProc;

After executing the example, query text is cleared. The identifier of object Query is Query.