At 01:21 PM 11/25/2014, Dennis McGrath wrote:
Very cool, Razzak.
One option has me confused.
>>5. Using selective column(s) when using SATTACH command
I looked at the new syntax diagram.
The USING clause has always indicated which columns make up the primary key.
Now it can also indicate which columns to attach.
What if you need to do both?
Dennis,
Here is the new syntax to SATTACH just some of the columns in the underlying
table.
There is a new "ONLY" keyword. Here is an example:
SATTACH SongList USING ONLY Song_ID, SongTitle
When you add the new keyword "ONLY" after the word USING, only the columns
listed will be"SATTACHed".
You can use this with temporary SATTACH too, and with column alias names.
It does not mention mixing the two.
Enjoy!
Very Best R:egards,
Razzak
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of A.
Razzak Memon
Sent: Tuesday, November 25, 2014 12:00 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - What's so special about R:Cornucopia Editions
What's so special about R:BASE 9.5 and Oterro 9.5 R:Cornucopia Editions!
R:BASE eXtreme 9.5 (32/64) - Update 4 (Build: 9.5.4.31125)
Oterro 9.5 (32/64) - Update 4 (Build: 9.5.4.31125)
http://www.rcornucopia.com/
In addition to all documented 64 enhancements and 125 reported and reliably
replicated fixed bugs, this special update also includes major enhancements
related to:
1. Connecting R:BASE eXtreme 9.5 (64) as a front-end to Pervasive database
using Oterro 9.5 (64)
2. Connecting R:BASE eXtreme 9.5 (64) as a front-end to MS SQL Server
database using Oterro 9.5 (64)
3. Designing & deploying complex web applications using R:BASE eXtreme 9.5
(64), Oterro 9.5 (64), and Node.js running on MS Windows Server 2012
4. Handling TEMPORARY ODBC tables in R:BASE eXtreme 9.5 (64)
5. Using selective column(s) when using SATTACH command
6. Using Multi-Line Headers/Footers when creating XLS or XLSW files
7. Managing BIGNUM data type when connecting to Oracle database
8. Handling TEMP tables in a MONSTER R:BASE eXtreme 9.5 (64) database with
"900+" tables and "16,000+" columns
9. Speedy Forms and External Form Files
Enjoy the showcase and pride of our eXpanded R:Dream Team!
The best is yet to come!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
31 years of continuous innovation!
16 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
