Online Documentation for SQL Manager for InterBase/Firebird
Using Navigation bar and Toolbar
The Navigation bar and Toolbar provide quick access to tools implemented in Procedure Editor.
Object
select a database
select a procedure for editing
General
compile the procedure (if it is being created/modified)
execute the procedure
show SQL help
set printing options to print metadata of the procedure
save the object using the Quick Save feature
load the object from buffers using the Quick Load feature
refresh the content of the active tab
toggle Text / Visual editor modes
restore the default size and position of the editor window
adjust Visual Mode Editors options
Tools
view the dependency tree for the procedure
define grants on the procedure
set autogrant privileges for the procedure
debug the procedure using Procedure/Trigger Debugger
Explorer
browse the procedure parameters and variables using the Explorer tree
Depending on the current tab selection, the Navigation bar expands to one or more additional panes with tab-specific actions that can be useful for working with the procedure:
Input Parameters / Output Parameters / Variables / Cursors
append a new input parameter / output parameter / variable / cursor
insert a input parameter / output parameter / variable / cursor
delete the selected input parameter / output parameter / variable / cursor
move the selected input parameter / output parameter / variable / cursor up
move the selected input parameter / output parameter / variable / cursor down
Permissions
Grant
Grant with Grant Option
Revoke
Grant All
Grant All with Grant Option
Revoke All
Grant on All
Grant on All with Grant Option
Revoke on All
Add grantee object
Description
save object description to file
copy description to clipboard
DDL
save DDL to file
open DDL in Execute Script
Items of the Navigation bar are also available on the ToolBar of Procedure Editor. To enable the toolbar, open the Environment Options dialog, proceed to the Windows section there and select Toolbar (if you need the toolbar only) or Both (if you need both the toolbar and the Navigation bar) in the Bar style for child forms group.