Thanks Razzak, I understand that part of the syntax. SATTACH SongList USING ONLY Song_ID, SongTitle
But, what do I do if I want to also indicate that Song_ID is to be used as the primary key? That syntax would be SATTACH SongList USING Song_ID It does not look like I can have 2 USING clauses, or can I? Thanks Dennis McGrath -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, November 25, 2014 12:43 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: What's so special about R:Cornucopia Editions 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! >--
