A script-enabled browser is required for this page to function properly.

Method Dialog

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.

icon to add a parameter

Click to add the parameter to the list. The Parameter Name field is cleared.

icon to remove a parameter

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.