At 11:42 AM 9/28/2021, Doug Hamilton wrote:
A computed column using
(IFNULL(TrackingDateTimeAdded,.#NOW,TrackingDateTimeAdded)) works
until the database is UNOADED and INPUTted - the column then gets
set to the DateTime of the input.
Change the database NOCALC setting to ON to avoid those results.
For complete details:
HELP NOCALC
Syntax: SET NOCALC ON/OFF
Default: OFF
NOCALC suppresses or processes computed column expressions with the
UNLOAD and LOAD commands.
If NOCALC is set to ON, then the UNLOAD command, as it creates LOAD
statements, will generate new "load only" commands as it starts each
table. These "load only" commands would be CALC and NOCALC, which
operate in a fashion similar to CHECK/NOCHECK and FILL/NOFILL and
NUM/NONUM commands. The UNLOAD command will output the current values
for the computed columns as it unloads the data.
In processing a LOAD command for a table, if it encounters a NOCALC
command, then regardless of the current setting for NOCALC, the LOAD
command will expect values for every column, whether computed or not.
The values from the input would then be stored in those columns that
are computed, rather than doing the actual computation.
NOCALC allow users to preserve original computed values when using
UNLOAD/LOAD to move data, or when rebuilding a database with UNLOAD ALL.
Other methods for adding rows to a table, such as APPEND , the Data
Browser, or a form, would all still calculate each computed column.
Only the LOAD command with its special CALC/NOCALC commands could
input a value into a computed column without doing the computation.
R:BASE stores the setting with the database.
Very Best R:egards,
Razzak
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/0MTjFe-1mMU7I1tMu-00QQeh%40mrelay.perfora.net.
