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.
