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

...