As you say, better safe than sorry. I guess that I've been a bit stricter than I needed to have been with myself but that's probably no bad thing. I'll keep to my first four characters as different from reserved words system.
I rarely use shortened forms of commands to make it easier to understand. SET VAR is pretty much the only one that I do use regularly. Regards, Alastair. ----- Original Message ----- From: "Bernard Lis" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Tuesday, March 22, 2005 2:54 PM Subject: [RBG7-L] - Re: Reserved Words > Alastair, > In my younger days, b4 7.0, I used to do "con dbname" to connect to a > database. I never had a problem with it. > Then it was pointed out to me that con could be either connect or continue. > So now I use "conn", just in case. > I think R:Base is smart enough to consider the context in which it was used > and that's probably why I never had a problem -- but why let the devil in to > do his mischief. > > Bernie Lis > > ----- Original Message ----- > From: "Alastair Burr" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Tuesday, March 22, 2005 3:31 AM > Subject: [RBG7-L] - Re: Reserved Words > > > > Maybe a good night's sleep and another look at the reserved word list will > > have cleared my mind: > > > > Yesterday, I thought that the first 4 characters of any reserved word were > > the unique part so you would be unwise to use those 4 characters (or the > > first three or two or one of them) as the name of a table/column or as the > > short-form of a command. > > > > A quick look at the reserved word list had shown RATE1, RATE2 & RATE3 but > > not RATE. My thought then was that using RATE would be liable to cause > > problems simply because it is the first 4 characters of 3 reserved words. > > On > > top of that, it seemed possible that RATE might easily be added to the > > list > > at some future date. > > > > This morning, with a more comprehensive look at the reserved word list, I > > can see that there are quite a few entries where the first four characters > > are not unique - various AUTO's and SOUNDS's are obvious examples, as well > > as the RATE's. > > > > Obviously R:Base can and does differentiate between words longer than 4 > > characters but that wasn't quite my concern. What did concern me was using > > the first 4 characters of a reserved word _might_ cause a problem. > > > > Actually reading the text that precedes the reserved word list in the > > in-line help this morning it says, and I quote: > > > > "Do not use these words or any shorter forms of them as names for columns, > > tables, or views." > > > > The printed manual for v5.5 went a bit further: > > > > "Do not use these words or any shorter forms of them as names for columns, > > forms, labels, reports, tables, views, or variables." > > > > Seems that not using RATE is probably a wise move <g>. > > > > Regards, > > Alastair. > > > > > > ----- Original Message ----- > > From: "claudinerobbins" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[email protected]> > > Sent: Tuesday, March 22, 2005 1:47 AM > > Subject: [RBG7-L] - Re: Reserved Words > > > > > >> OK, that 'splains it... I'm gonna make it simple and name it anything > >> but > >> RATE <g>... > >> > >> -----Original Message----- > >> From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB > >> Sent: Monday, March 21, 2005 6:18 PM > >> To: RBG7-L Mailing List > >> Subject: [RBG7-L] - Re: Reserved Words > >> > >> Ok.. RATE was a bad example because of RATE1, RATE2, and RATE3 being > >> Reserved > >> words, but the rule still applies that you could use RATE1x, RATE2x, or > >> RATE3x, > >> where x is another character without any conflicts. > >> > >> > >> ----- Original Message ----- > >> From: "claudinerobbins" <[EMAIL PROTECTED]> > >> To: "RBG7-L Mailing List" <[email protected]> > >> Sent: Monday, March 21, 2005 7:08 PM > >> Subject: [RBG7-L] - Re: Reserved Words > >> > >> > >> > I said RStyle highlights "it" meaning RATE. > >> > > >> > Are you saying that RATE1 can be used although it is used in a > >> > function? > >> > > >> > -----Original Message----- > >> > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB > >> > Sent: Monday, March 21, 2005 5:57 PM > >> > To: RBG7-L Mailing List > >> > Subject: [RBG7-L] - Re: Reserved Words > >> > > >> > I'm thinking you are confusing the rule (or I am?). > >> > > >> > AFAIK, You wouldn't want to name anything 3 or 4 characters total > >> > length > >> > that > >> > would be the first 3 or 4 characters of a reserved word, as you know > > RBase > >> > interprets that as the full length reserved word, but you could use the > >> > first 3 > >> > or 4 characters of any reserved word as long as an additional character > >> was > >> > added that distinguished it from the Reserved word. > >> > > >> > Let's use the RATE example. > >> > > >> > You would NOT want to name a column or object RAT or RATE, but RAT1 or > >> RATE1 > >> > would be acceptable. > >> > > >> > I don't know how Claudine thought that RATE1 was highlighted in RBE. > >> > > >> > It does not highlight in mine, nor does RAT, RAT1, or RATE1. > >> > RATE by itself is the only thing that highlights. > >> > > >> > > >> > ----- Original Message ----- > >> > From: "Alastair Burr" <[EMAIL PROTECTED]> > >> > To: "RBG7-L Mailing List" <[email protected]> > >> > Sent: Monday, March 21, 2005 6:44 PM > >> > Subject: [RBG7-L] - Re: Reserved Words > >> > > >> > > >> > > Mike, > >> > > > >> > > I thought that you had to keep the first 4 characters > >> > > unique/different > >> > from > >> > > reserved words - or has that changed without my noticing it? > >> > > > >> > > At the same time, RATE1/2/3 obviously have 5 but the first 4 are the > >> same > >> > - > >> > > so I'm confused. > >> > > > >> > > Regards, > >> > > Alastair. > >> > > > >> > > > >> > > ----- Original Message ----- > >> > > From: "MikeB" <[EMAIL PROTECTED]> > >> > > To: "RBG7-L Mailing List" <[email protected]> > >> > > Sent: Monday, March 21, 2005 11:27 PM > >> > > Subject: [RBG7-L] - Re: Reserved Words > >> > > > >> > > > >> > > > But...... Rate1 <> Rate... > >> > > > > >> > > > You can take any RBase Reserved word and add 1 letter to it and > >> RBase > >> > > won't > >> > > > complain because they are not equivlent... > >> > > > > >> > > > ----- Original Message ----- > >> > > > From: "claudinerobbins" <[EMAIL PROTECTED]> > >> > > > To: "RBG7-L Mailing List" <[email protected]> > >> > > > Sent: Monday, March 21, 2005 6:23 PM > >> > > > Subject: [RBG7-L] - Re: Reserved Words > >> > > > > >> > > > > >> > > > > Alastair, > >> > > > > > >> > > > > Yes, I was thinking the same thing, better safe than sorry... > >> > > > > > >> > > > > Thanks :) > >> > > > > > >> > > > > -----Original Message----- > >> > > > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of > >> Alastair > >> > > Burr > >> > > > > Sent: Monday, March 21, 2005 4:59 PM > >> > > > > To: RBG7-L Mailing List > >> > > > > Subject: [RBG7-L] - Re: Reserved Words > >> > > > > > >> > > > > Claudine, > >> > > > > > >> > > > > These are 3 functions that give interest rates - I would advise > > you > >> > not > >> > > to > >> > > > > use RATE if you can avoid it. It may work for you now but in the > >> > > future... > >> > > > > > >> > > > > Regards, > >> > > > > Alastair. > >> > > > > > >> > > > > ----- Original Message ----- > >> > > > > From: "claudinerobbins" <[EMAIL PROTECTED]> > >> > > > > To: "RBG7-L Mailing List" <[email protected]> > >> > > > > Sent: Monday, March 21, 2005 10:37 PM > >> > > > > Subject: [RBG7-L] - Reserved Words > >> > > > > > >> > > > > > >> > > > > > RATE1, RATE2 and RATE3 are reserved words, and even though RATE > > is > >> > not > >> > > on > >> > > > > > the list, RStyle highlights it as if it were. Does anyone know > > if > >> > > there is > >> > > > > > any danger in using this for a field name? (inherited from > >> > Oracle...). > >> > > > > > > >> > > > > > TIA, > >> > > > > > > >> > > > > > Claudine :) > >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > >> > > > > --- RBG7-L > > ================================================ > > TO POST A MESSAGE TO ALL MEMBERS: > > Send a plain text email to [email protected] > > > > (Don't use any of these words as your Subject: > > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [email protected] > > In the message SUBJECT, put just one word: INTRO > > ================================================ > > TO UNSUBSCRIBE: > > Send a plain text email to [email protected] > > In the message SUBJECT, put just one word: UNSUBSCRIBE > > ================================================ > > TO SEARCH ARCHIVES: > > Send a plain text email to [email protected] > > In the message SUBJECT, put just one word: SEARCH-n > > (where n is the number of days). In the message body, > > place any > > text to search for. > > ================================================ > > > > >
