| Subject | Order of calculating COMPUTED fields for a single table |
|---|---|
| Author | Raymond Kennington |
| Post date | 2003-06-09T17:26:03Z |
A table as 3 COMPUTED fields: F1, F2 and F3 : DOUBLE PRECISION.
F1 is computed from a table T1.
F2 is computed from a table T2.
F3 is computed as "Initial Amount" - F1 - F2 - <a computed value from table
T3>.
If I place the fields F1 and F2 before F3 in the creation order of the fields
in the table, will F3 be calculated after F1 and F2?
If so, does the order of F1, F2 and F3 matter?
TIA
--
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)
F1 is computed from a table T1.
F2 is computed from a table T2.
F3 is computed as "Initial Amount" - F1 - F2 - <a computed value from table
T3>.
If I place the fields F1 and F2 before F3 in the creation order of the fields
in the table, will F3 be calculated after F1 and F2?
If so, does the order of F1, F2 and F3 matter?
TIA
--
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)