|  Organizer Advantage HowTo/Help  |  Designer HowTo/Help  | 

Designer Help > Data Fields, Controls > Advanced > Calculated

Text, Numeric (Advanced)

You can define SQL Query attribute for Text and Numerical data fields. When this attribute is defined Organizer Advantage executes the query or the calculations and stores the result in this field. It happens in two situations: when you create a new record or when you modify an existing one. The field value is stored in the table.

There is additional attribute called IsSavedOnce that could be used in connection with the SQL Query. If you enter Y for this attribute the SQL Query is only executed once when the new record is created and then saved.

The program displays the value of this field on the record form, on the grid, in reports, statistics, you can use this field in the search or the sort functions, and you can use this field in other query or calculation definitions.

Organizer Advantage is using Firebird SQL. When defining SQL attribute use Firebird operators and functions:

• arithmetic operators: +, -, *, /
• concatenation operator: || (double-pipe) (’PO-’||ID)
• constants: a number (12.22, 2) or a string enclosed in apostrophes (‘text string’, ‘123.12’)
• functions: CURRENT_DATE, BIN_OR(N1,N2)

Text, Numeric data fields with SQL Query:

BARCODE, text field:

ENTERED, text field:

MODIFIED, text field:

TOTAL, numeric field:

TAX_VALUE, numeric field:

FINAL_PRICE, numeric fields:

Organizer Advantage, Simple Database Solutions for Windows PC

Organizer Advantage, Business Database Solutions for Windows PC

Organizer Advantage Free Service

Organizer Advantage Support