Add Method - Procedures Collection

Description

Creates a stored procedure with the given name and type. Procedure types include: 0 = SQL Procedure, 1 = SQL Function. PARAMETERS: Name (String), ProcedureType (Integer).

Syntax

Public Function Add( _
   ByVal Name As Variant, _
   ByVal ProcedureType As Variant _
) As Procedure

Parameters

• Name
• ProcedureType

Example

Dim MyModel As Model

Dim MyProc As Procedure

Dim ProcName As String

Dim ProcType As Integer

'Setting ProcType to 0 to represent a SQL procedure

ProcName = "LatestProc"

ProcType = 0

Set MyProc = MyModel.Procedures.Add(ProcName, ProcType)