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 > > > >
