You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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 (String). RETURN DATATYPE: String.

 UserComments

Returns a collection of User Comments associated with this object.

Public Properties

PropertiesDescription

 Description

Description of the stored procedure. DATATYPE: String.

 GUID

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

 ID

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

 Name

Name of the stored procedure. DATATYPE: String.

 Owner

Owner of the stored procedure. DATATYPE: String.

 Text

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

 Type

Type of the stored procedure. Valid values are: 0 = SQL Procedure, 1 = SQL Function, 2 = Basic Procedure, 3 = Basic Function. DATATYPE: Integer.

  • No labels