Tom - If you look at the SELECT Functions part of the Help documentation, it shows the three-character spelling only - BUT the COMPUTE and CROSSTAB syntax spell out MINIMUM and MAXIMUM but leave average as AVG. It's always been that way .... at some point you just finally remember the distinction ... and if not, you post it here again and someone will set you straight.
And you have to remember that RStyle is still a work in progress - it's a wonderful help but it's not always 100% accurate...If it's changing MIN to MINIMUM in your syntax where it's not valid, you should submit it as a bug on the R:DCC. Sami > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Thomas > Eldred > Sent: Friday, August 20, 2004 7:44 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: illegal column specification?????? > > > hmmm, thanks Bill > > It is curious, but the reference book I've come to rely on (the > R:Base sytax > dictionary) spells out maximum and minimum in the reading sytax > portion . . > .. and they appear in the reserved word list (as does average). > > Thank you for clarifying . . . perhaps a revision to the > dictionary might be > inorder? > > tom > ----- Original Message ----- > From: "Bill Downall" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Friday, August 20, 2004 8:22 AM > Subject: [RBG7-L] - Re: illegal column specification?????? > > > > Tom, > > > > AVG, MIN, MAX, SUM, and COUNT are standard SQL syntax. The fully spelled > out > > words are not. > > > > The MINIMIZE and MAXIMIZE keywords are not in the reserved word list in > R:Style > > because of the SELECT syntax, but because of separate R:BASE > commands that > > control the size of the R> prompt window. > > > > R:Style also has configuration settings and files that enable you to > specify words (like > > column names, database names, and new keywords) that it should > NOT expand > to > > full spelling. > > > > Bill > > > > On 20 Aug 2004 at 8:21, Thomas Eldred wrote: > > > > > Again thank you for the suggestion. The change from spelling the words > > > average, minimum and maximum to avg, min and max cleared the error. > > > > > > but I am curious as to why the functions would not work spelled out? > > > In one instance of checking the view code, R:Style (?) converted my > > > MIN to minimize and was giving me both an error (illegal database > > > name) and minimized my file? that is why i decided to spell them > > > out...and I had thought that was good practice anyhow? > > > > > > Happy FRIDAY, hope everyone has great excitment ahead for the weekend > > > > > > > > > > >
