Calculated data fields do not store the calculated value in the table. Calculated data fields are dynamic. The value of this field is recalculated for all records every time you load a table and only for the newly selected record. The value is calculated according to the arithmetic, string processing, or simple SQL query formula.
The program displays the value of this field on the record form, on the grid, in reports, statistics, or you can use this field in search or sort functions.
Use this field type in complex database solutions when modification of some values in the record and the use of variable parameters (current time, current year, current date, ...) requires dynamic recalculations.
Organizer Advantage is using Firebird SQL. In calculated data fields use Firebird operators or functions:
If you want to use a calculated field in your table:
In the below database sample there is a table: CLUB_MEMBERS.
Copyright © 2021 · All Rights Reserved · PrimaSoft PC