Stored Procedures

Creating a stored procedure

To create a new stored procedure, do the following:

• In the Repository window, open the application folder where you want to create the stored procedure.
• Select the "Database" folder.
  Right-click on the "Stored Procedures" sub-folder and choose "Insert Stored Procedure" from the popup-menu. A dialog box will be displayed : 

• Specify a value in the "Name" field. The "Description" field is optional.  You may choose to copy an existing stored procedure by selecting a name from the "Copy From" listbox. Stored procedures that are currently locked will not appear in the "Copy From" list. Click "OK" to add the stored procedure.
• The "Options" screen will appear, showing the Name and Description you entered. To complete the specification, see "Adjusting a stored procedure" below.

Adjusting a stored procedure

When you double-click on a stored procedure name, the "Options" screen for it will be shown by default. You specify further details by clicking the nodes in the left-hand window pane, namely:

On completion, save the stored procedure. The save buttons can be found in the top toolbar of the Developer.

The stored procedure must be checked in first before it can be called from other objects.

Deleting a stored procedure

A stored procedure can be removed from the repository through the Revision Control screen.

 

Generate the application and reorganize the database

After a stored procedure is added, adjusted or deleted, a Whole System generate is required, followed by a database reorganize.