ISecurityConnection.Procedures

Syntax

Procedures(ProcedureName: String): IDalProcedures;

Parameters

ProcedureName. Procedure physical name in database.

Description

The Procedures property returns the cursor containing system information about the procedure, which physical name is sent by input parameter.

Example

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 procedure with the Procedure_1 physical name.

Sub UserProc;
Var
    MB: IMetabase;
    DB: IDatabaseInstance;
    Cur: IDalProcedures;
    Field: IDalCursorField;
Begin
    MB := MetabaseClass.Active;
    DB := MB.ItemById("DB").Open(Null) As IDatabaseInstance;
    Cur := DB.Connection.Procedures("Procedure_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 procedure.

See also:

ISecurityConnection