Online Documentation for SQL Manager for InterBase/Firebird

Executing procedure


Procedure Editor provides an ability to execute procedures. Click the btnExecuteQuery Execute item of the Navigation bar or use the corresponding toolbar button to execute the procedure.

 

If the procedure has input parameters, SQL Manager allows you to specify the values for these parameters in the Input Parameters dialog which appears just before execution.

 

The result of the successfully executed procedure, as well as the error message in case of execution failure, appears in the message panel at the bottom of the Procedure Editor window.

 

Procedure Editor - Executing procedure

 

Note: If any unsaved changes are applied to the stored procedure being currently edited, the execution of the procedure is impossible unless changes are saved through the Compile item of the Navigation bar.