Views(Value: String): IDalViews;
ViewName. Physical name of view in database.
The Views property returns the cursor containing system information about the view, which physical name is sent by input parameter.
Executing the example requires that the repository contains a database with the DB identifier. The database server, to which the database is set up, has a view with the View_1 physical name.
Sub UserProc;
Var
MB: IMetabase;
DB: IDatabaseInstance;
Cur: IDalViews;
Field: IDalCursorField;
Begin
MB := MetabaseClass.Active;
DB := MB.ItemById("DB").Open(Null) As IDatabaseInstance;
Cur := DB.Connection.Views("View_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 UserProc;
After executing the example, connection to the database server, on which the database database is set, is established. The development environment console will display system information about the specified view.
See also: