The Method dialog box has two pages: Definition and Restrictions. The pages allow you to define an object type method and its parameters, and restrictions for the type.
The Definition page enables you to specify a method name and type, and optional parameters. For functions, you can specify a return type. The page consists of the following:
Method Name |
Type a name for a method. This name cannot be the same as the object type name or any of the object type attributes. |
Method Type |
Choose a method type from the drop-down list. The method types are Procedure, Function, Map Function, and Order Function. Map Function and Order Function are comparison methods. You can specify either a map function or an order function for an object type, but not both. |
Return Type |
For functions, choose a return type from the drop-down list. |
Parameter Name |
Type a name for a parameter. |
Datatype |
Choose a Built-in datatype from the drop-down list. To browse existing object types, click the ... button to display the Type Selection dialog box. |
Direction |
Choose IN, OUT or IN/OUT from the drop-down list. |
Default Value |
Type a default value for the parameter. |
|
Click to add the parameter to the list. The Parameter Name field is cleared. |
|
Click to remove the highlighted parameter from the list. A message box displays, prompting for confirmation. |
List box |
Displays the list of parameters defined for the method. To change the parameter definition order in the list box, click the parameter and drag it to the new position. |
The Restrictions page enables you to override the default pragma restrictions already defined for the object type. Pragma restrictions apply to member functions called from SQL statements. The restrictions deny member functions read/write access to database tables, packaged variables, or both. The Restrictions page consists of the following:
Override Default Restrictions |
Check this box to use the method restrictions in place of the default restrictions, then specify the constraints by checking or unchecking the options below. Uncheck this box to use the default pragma restrictions. The options below are disabled when this check box is unchecked. |
RNDS, WNDS, RNPS, WNPS |
Check the appropriate check box to enforce the rule. Uncheck the appropriate check box to remove the rule. |