ISecurityConnection.Tables

Syntax

Tables(Value: String): IDalTables;

Parameters

Value is a physical name of the table in DB.

Description

The Tables property returns the cursor, containing system information about the table, which physical name is passed by the Value parameter.

Example

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

Sub Main;

Var

MB: IMetabase;

DB: IDatabaseInstance;

Cur: IDalTables;

Field: IDalCursorField;

Begin

MB := MetabaseClass.Active;

DB := MB.ItemById("BD").Open(Null) As IDatabaseInstance;

Cur := DB.Connection.Tables("Table_1");

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 Main;

After executing the example connection to the DB server, on which the BD repository database is set, is performed. System information about the table with the "Table_1" physical name, if there is such on the server, is displayed in the development environment console.

See also:

ISecurityConnection