Online Documentation for SQL Manager for InterBase/Firebird

Creating/editing SQL Functions


Use the SQL Function tab of SQL Function Editor to view and edit SQL functions.

 

Name

Name of the SQL function.

 

SQL Function - Editing SQL Function

 

Input parameters

This group is provided for managing the list of input parameters passed to the SQL function.

 

The Input parameters list provides the following attributes of each input arguments of the SQL function:

Name, Default value, Parameter type, Not Null attribute and Description.

 

Click the arrow-down button to call Data Type Editor for setting properties of the parameter data type. It allows you to select the source type for the argument being created/edited. It can be one of existing domains, a standard InterBase/Firebird data type or a column.

 

Output parameters

This group is provided for managing the list of output parameters passed to the SQL function.

 

The Output parameters list provides the following attributes of each input arguments of the SQL function:

Name, Parameter type, Not Null attribute.

 

Click the arrow-down button to call Data Type Editor for setting properties of the parameter data type. It allows you to select the source type for the argument being created/edited. It can be one of existing domains, a standard InterBase/Firebird data type or a column.

 

Variables/Cursors

This group allows you to select the source type for the return parameter being created/edited. It can be one of existing domains or a standard InterBase/Firebird data type. For detailed information see Managing parameters.

 

The lower area allows you to specify the function body.

 

To compile an SQL Function use the iconCompile Compile item available within the Navigation bar or toolbar.