Versions Compared

Old Version 1

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version Current

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Code Block
languagevb
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)


Info
titleSee Also