Online Documentation for SQL Manager for InterBase/Firebird

Defining procedure


The Procedure page allows you to specify properties of the procedure wrapper to be created along with the autoincrement field.

 

Tables - Field Editor - Autoincrement - Procedure

 

CheckBox Create procedure wrapper

Enable the option to create a procedure wrapper. Procedure wrapper returns a new generator value and can be used instead of GEN_ID for a specific generator.

 

Procedure definition

A block of statements in InterBase procedure and trigger language bracketed with BEGIN and END.

 

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