Procedures
A stored procedure is a self-contained program written in InterBase procedure and trigger language, and stored as part of a database's metadata. Stored procedures can be invoked directly from applications, or can be substituted for a table or view in a SELECT statement. Stored procedures can receive input parameters from and return values to applications and can execute on the server.
To create a new procedure:
- Select the Database | New Object... menu item.
- Select Procedure in the New Object dialog.
- Edit procedure within the Procedure Editor.
Hint: To create new procedure you can also right-click the Procedures node of the explorer tree and select New Procedure... item from the popup menu.
To create a new procedure with the same properties as one of the existing procedures has:
- Select the Database | Duplicate Object... menu item.
- Follow the instructions of the Duplicate Object Wizard.
To edit an existing procedure:
- Select the procedure for editing in the explorer tree (type the first letters of the procedure name for quick search)
- Right-click and select the Edit Procedure item from the popup menu or simply double-click the procedure.
- Edit procedure definition in the editor area of the Procedure Editor.
To change the name of a Procedure:
- Select the procedure to rename in the explorer tree.
- Right-click and select the Rename Procedure item from the popup menu.
- Edit procedure name in the dialog window.
To execute a procedure:
- Select the procedure in the explorer tree (type the first letters of the procedure name for quick search).
- Right-click and select Edit Procedure item from the popup menu or simply double-click the procedure.
- Execute procedure by clicking on the Execute Procedure item in the Procedure Editor.
To drop a Procedure:
- Select the procedure to drop in the explorer tree.
- Right-click and select the Drop Procedure item from the popup menu.
- Confirm dropping in the dialog window.
