Razzak, Very nice!
Jan -----Original Message----- From: "A. Razzak Memon" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 09 Jan 2015 11:31:08 -0500 Subject: [RBASE-L] - Tip of the Day: Preserving Computed Column Values When UsingUNLOAD/LOAD Commands Friday, January 9, 2015 Tip of the Day: Preserving Computed Column Values When Using UNLOAD/LOAD Commands Product.: R:BASE eXtreme 9.5 (32/64) Build...: 9.5.5.20909 or higher www.rupdates.com [http://www.rupdates.com/] www.rbaseupdates.com [http://www.rbaseupdates.com/] Section.: R:BASE Settings Keywords: NOCALC Did you know that users of R:BASE eXtreme 9.5 (32/64), Update 5, now can preserve original computed values when using UNLOAD or LOAD commands to move data, or when rebuilding the entire database with UNLOAD ALL? A new database settings of NOCALC has been implemented in the latest version and build of R:BASE eXtreme 9.5 (32/64), Update 5, Build: 9.5.5.20109. NOCALC allow users to preserve original computed values when using UNLOAD/LOAD to move data, or when rebuilding a database with UNLOAD ALL. 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. 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 eXtreme 9.5 stores the NOCALC setting with the database. Have fun implementing NOCALC settings when using UNLOAD/LOAD routines in your R:BASE applications. Very Best R:egards, Razzak. www.rbase.com [http://www.rbase.com/] www.facebook.com/rbase [http://www.facebook.com/rbase] -- 32 years of continuous innovation! 17 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
