Online Documentation for SQL Manager for InterBase/Firebird

Specifying 'COMPUTED BY' expression


If you select the RadioButton 'COMPUTED BY' expression option of the Field based on group indicating that values of the field being created/edited will be calculated according to an expression, you should specify the 'COMPUTED BY' expression in the editable area below.

 

Tables - Field Editor - Specifying COMPUTED BY expression

 

Set the expression to be used for calculation, e.g.

(OLD_SALARY + OLD_SALARY * PERCENT_CHANGE / 100)

 

Note the following:

  • the expression can be any arithmetic expression valid for the data types in the expression;
  • any columns referenced in the expression must exist before they can be used in expression;
  • the expression cannot reference BLOB columns;
  • the expression must return a single value, and cannot return an array.

 

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.