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 SQL Function editor.

Object

select a database

select an SQL function for editing

General

execute the current SQL Function

compile the SQL function (if it is being created/modified)

show SQL help

set printing options to print metadata of the SQL function

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

switches between Text and Visual editor modes

adjust Object Editors options

restore the default size and position of the editor window

Tools

view the dependency tree for the SQL function

define grants on the SQL Function

set autogrant privileges for the SQL Function

debug the SQL Function using Debugger

create a view based on the SQL Function

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 SQL function:

Input Arguments

append a new input argument

insert an input argument

delete the selected input argument

move the selected input argument up

move the selected input argument down

Export list - use it to export the arguments list to the specified format

Description

save object description to file

copy description to clipboard

DDL

save DDL to file

open DDL in Execute Script

NOTE: Items of the Navigation bar are also available on the ToolBar of UDF 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.