Ken,
While we take great pride in our work and implementation of any
enhancement request, it is really the developers, like you, who help
us add to the "arsenal" of great tools available in R:BASE!
Thank you for taking the precious time to submit the requests and
explain all details about both enhancements implemented in the latest
"Update 2" of R:BASE X.5 (Version 10.5).
Thank you for testing both enhancements and providing valuable
feedback before the official release of Update 2.
Our success is the reflection of clients and developers like you,
with a vested interest in R:BASE!
Thank you!
Very Best R:egards,
Razzak
At 08:08 PM 11/11/2019, Ken Shapiro wrote:
And....to add to this, the codelock 6 enhancement and fix for a
large amount of text within the codelocked file.
Regards, Ken
-----Original Message-----
From: [email protected] [mailto:[email protected]] On
Behalf Of Ken Shapiro
Sent: Monday, November 11, 2019 7:49 PM
To: [email protected]
Subject: Re: [RBASE-L] - Tip of the Day: Duplicate a Column
Definition with ALTER/CREATE TABLE Commands
Razzak,
Thank you for implementing this R:BASE enhancement from my original
suggestion. It is a very useful and cool enhancement added to the
"arsenal" of great tools available in R:BASE.
Best regards,
Ken
On Mon, Nov 11, 2019 at 11:20 AM A. Razzak Memon <[email protected]> wrote:
Monday, November 11, 2019
Tip of the Day: Duplicate a Column Definition with
ALTER/CREATE TABLE Commands
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.2.11111 or higher
Sections......: Commands
Keywords......: ALTER TABLE, CREATE TABLE, DUPLICATE,
Column, Definition
Did you know the ALTER TABLE and CREATE TABLE commands were enhanced
to duplicate the definition of a column that already exists
in another
table?
The implemented ability will "duplicate" the definition of
a column that
already exists in the database in another table. The
enhanced syntax uses
"DUPLICATE" as a keyword followed by the table and column
name, for which
the column definition is to be duplicated.
The DUPLICATE keyword will copy the data type, length, any
default value,
and the NOT NULL flag, if any. It will not support computed
columns. It
will also not duplicate any description for the column.
-- ALTER TABLE Example:
ALTER TABLE TSALES_ORDERS +
ADD COLUMN CUST_DESC +
DUPLICATE CUSTOMERS.CUST_DESC
-- CREATE TABLE Example:
CREATE TEMPORARY TABLE Temp1 +
(tEmpID INTEGER, +
tEmpWebAddr DUPLICATE EMPLOYEE.WEBADDRESS, +
tEmpStartDate DATE)
The above will create the column tEmpWebAddr with the same
type and default
value as WEBADDRESS in the EMPLOYEE table.
The enhancement is helpful in ALTER TABLE ... ADD COLUMN
situations, to be
able to add a column dynamically by creating the column
definition from the
attributes of a column in another table.
Very Best R:egards,
Razzak.
https://www.rbase.com
http://www.facebook.com/rbase/
--
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]
<mailto:rbase-l%[email protected]> .
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/201911111620.xABGK2pg025893%40atl4mhob25.registeredsite.com.
--
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/CADeqk-7gfdO52NAvuyCt%3DsVm5ovUztoHEaNM%3DAO9N1o%2BOQPf5A%40mail.gmail.com
<https://groups.google.com/d/msgid/rbase-l/CADeqk-7gfdO52NAvuyCt%3DsVm5ovUztoHEaNM%3DAO9N1o%2BOQPf5A%40mail.gmail.com?utm_medium=email&utm_source=footer>
.
--
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/001b01d598f5%24bd275a60%2437760f20%24%40optonline.net.
--
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/201911120154.xAC1scCp017002%40atl4mhob23.registeredsite.com.
