Friday, August 28, 2015 Tip of the Day: About the New COLCHECK Setting Product.: R:BASE eXtreme 9.5 (32/64) and R:BASE X (Version 10) Build...: 9.5.5.20924, 10.0.1.10924 or higher Section.: Settings Keywords: COLCHECK, CREATE VIEW, CREATE TEMPORARY VIEW, AS alias
Did you know that the upcoming update of R:BASE eXtreme 9.5 (32/64) and the official release of R:BASE X (Version 10), to be released on September 24, 2015, include a new COLCHECK setting? The additional COLCHECK setting has been introduced to manage common column names and corresponding data types when used as ALIAS names while defining a new VIEW or modifying an existing VIEW. COLCHECK specifies if columns will be checked for consistency when making views. When COLCHECK is ON (the default), view alias/column names will be checked for consistency to other occurrences of those names in the database, when the view is created. Syntax: SET COLCHECK ON/OFF Similar checking is already in place when creating or modifying tables, and when attaching tables to a database, where R:BASE requires an alias that does not cause name/data type conflicts. If an application requires COLCHECK be off to define a view, the proper results should not be expected once COLCHECK is switched back to ON when using the view. If a view needs to be created with COLCHECK OFF, it also needs to be used with COLCHECK OFF. An impact may occur for a view that has already been defined, because when COLCHECK is ON, the values generated for the view will follow the data type of the alias. If an error occurs, the view definition should be reviewed. Note: Customers with VIP status may request a private version of R:BASE eXtreme 9.5 or RBASE X (version 10) for their internal testing. Send your request to mailto:[email protected] Very Best R:egards, Razzak. www.rbase.com www.rbaseX.com www.facebook.com/rbase -- 32 years of continuous innovation! 17 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
