Friday, December 20, 2013
Tip of the Day: Computed Columns and Default Values
Product.: R:BASE eXtreme 9.5 (32/64)
Build...: 9.5.3.21205 or higher www.rupdates.com
Keywords: Data Designer, RBDEFINE, CREATE TABLE
Section.: Computed Columns
While upgrading and migrating legacy R:BASE databases to R:BASE eXtreme
9.5 (32/64), a warning message will be displayed if the legacy table
column contains a default value for a computed column.
If the command syntax to CREATE a table defines a default value on a
computed column, the table will be created, however, a warning message
will be displayed, but the default value on the computed column will
not be added.
IMPORTANT NOTE:
This may alert some users if they inadvertently added a default value
to a column definition, and then decided to change that column to a
computed value, but did not remove the default value.
R:BASE eXtreme 9.5 (32/64) Data Designer (RBDef) and the CREATE TABLE
command has been enhanced to display warning message and ignore default
value, if defined, for a computed column.
While converting legacy database(s), you will also notice the warning
message when building a fresh database using R:BASE eXtreme 9.5 from
an output file that was created using the UNLOAD command based on a
legacy database, only if the build process finds a default value for
computed column.
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
30+ years of continuous innovation!
15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
