EMS logo

Products Navigation

SQL Manager for IB/FB

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for InterBase/Firebird

On-line Documentation

Creating/editing procedure


Use the Stored Procedure tab of Procedure Editor to view and edit the stored procedure definition.

 

Procedure Editor provides two modes: Text editor and Visual editor. To switch between these editor modes, use the corresponding items available in the General group of the Navigation bar and toolbar.

 

Procedure Editor - Editing procedure definition

 

 

When in the Text editor mode, you can use the editor area to specify the procedure definition as SQL statement using a template, hence it is enough to simply edit the template using the editor area to make appropriate changes, and compile the procedure.

 

For your convenience the syntax highlight, code completion and a number of other features for efficient SQL editing are implemented. For details see Working with SQL Editor area and Using the context menu.

 

 

When in the Visual editor mode, you are provided with a set of widgets allowing you to benefit from graphical user interface while editing the object properties.

 

Name

Enter a name for the new procedure, or modify the name of the procedure being edited. Note that procedure name must be unique among procedure, table and view names in the database.

 

 

The Parameters and variables area allows you to manage input parameters, output parameters, variables and cursors at the corresponding tabs.

 

 

The lower area allows you to specify the procedure body, i.e. an optional list of local variables and their data types and a block of statements in InterBase procedure and trigger language, bracketed by BEGIN and END. When editing the procedure, you can edit its body using the editor area to make appropriate changes, and recompile the procedure.

 

 

To compile a procedure, you can use the iconCompile Compile item available within the Navigation bar or toolbar.

 


See also:

Managing parameters

Specifying input parameters