Versions Compared

Key

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

Public Methods

MethodDescription

 BoundAttachments

Get all of the BoundAttachments of this Procedure.

 ObjectPermissions

Returns the collection of Object Permissions for this object.

 SetText

Sets the Text (SQL) for the Procedure. Returns the validation error message or none if validated succesfully. PARAMETERS: NewText as (String). RETURN DATATYPE: String.

 UserComments

Returns a collection of User Comments associated with this object.

Public Properties

PropertiesDescription

 Description

This is the description Description of the stored procedure. DATATYPE: String.

 GUID

GUID of the stored procedure . This GUID is as assigned by ER/Studio. Each stored procedure has a unique GUID. DATATYPE: String.

 ID

ID of the stored procedure . This ID is as assigned by ER/Studio. Each stored procedure in a diagram has a unique ID. DATATYPE: Integer.

 Name

This is the name Name of the stored procedure. DATATYPE: String.

 Owner

This is the Owner of the stored procedure. DATATYPE: String.

 Text

This is the body Body text (SQL) of the stored procedure. DATATYPE: String.

 Type

This is the type Type of the stored procedure. The possible Valid values are: 0 = SQL Procedure - 0, 1 = SQL Function - 1, 2 = Basic Procedure - 2, 3 = Basic Function - 3. DATATYPE: Integer.

Info
titleSee Also