IDalConnection2.Discover

Syntax

Discover(SystemDictionary: DalSystemDictionary; Filter: String): IDalCursor;

Parameters

SystemDictionary. Type of cursor received after executing the SQL query to the database.

Filter. Filter that is applied to the cursors received after executing the SQL query to the database.

Description

The Discover method returns the appropriate cursor depending on the SystemDictionary parameter.

Comments

If the driver does not support the appropriate SystemDictionary, Null is returned.

While executing SQL query, the requested cursor is returned depending on the schema specified in database properties.

Example

Executing the example requires that the repository contains a database with the BD identifier.

Add links to the Metabase and Dal system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    DB: IDatabaseInstance;
    Cur: IDalCursor;
    Field: IDalCursorField;
Begin
    MB := MetabaseClass.Active;
    DB := MB.ItemById("BD").Open(Null) As IDatabaseInstance;
    Cur := DB.Connection.Discover(DalSystemDictionary.Tables, "");
    While Not Cur.Eof Do
        For Each Field In Cur.Fields Do
            Debug.WriteLine(Field.Name + " " + Field.Value);
        End For;
        Debug.WriteLine("");
        Cur.Next;
    End While;
    Cur.Close;
End Sub UserProc;

After executing the example the console displays system information about the tables stored in the database.

See also:

IDalConnection2