Razzak Gee I wish I could join you in California, but the stars are not aligned properly! (grin)
I am using Front End Build: 7.5.12.30720 downloaded last night and again today just in case. select top 5 * from invoiceheader results in -ERROR- Column top not found (2369) And this doesn't answer my original question: how would i tell R:Base I want the top 5 by tax as opposed to freight? I tried: select top 5 transid,tax from invoiceheader select top 5 transid,freight from invoiceheader but both result in -ERROR- Column top not found (2369) David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, July 20, 2005 10:19 PM Subject: [RBG7-L] - Re: Using the New "TOP n" Qualifier in SELECTCommands > At 10:05 PM 7/20/2005, David Blocker wrote: > > >I tried this command in 7.5 on the RRBYW10 database, build > > > >select top n * from invoiceheader > > > >and got > > > >ERROR - column top not found > > > >1. Has this not been implemented yet? > >2. How does R:Base know what column to work with for the "top"? > > In this case, top 5 by NetAmount? By Freight? By Tax? By > > Invoicetotal? > > > David, > > I bet you are not using the latest and great version of R:BASE > 7.5 for Windows (Build: 7.5.11.30720 or higher). > > Would you like to see a demo along with a few examples and MORE? > > You are welcome to join me at the Advanced R:BASE 7.5 for Windows > training class at the Hilton La Jolla, California this weekend. > > Very Best R:egards, > > Razzak. > > >
