Agreed in general. I make an exception in the case of name lookups when the lookup table includes both people and companies. In that case I use the last name field for the company name and leave the first name field null. I would hate having to choose in advance whether I'm looking up a person or a company.
I also make a pretty big exception to the rule when I use my transaction header table as the basis for my appointment book, and for date/time stamping of several other tables. On Mon, Apr 9, 2012 at 11:05 AM, Dennis McGrath <[email protected]> wrote: > One always runs in to trouble eventually when one db field has multiple > meanings.**** > > A big part of the problem is remembering the rules and the coding to > support them.**** > > It just makes for difficult maintenance.**** > > ** ** > > Dennis McGrath**** > > Software Developer**** > > QMI Security Solutions**** > > 1661 Glenlake Ave**** > > Itasca IL 60143**** > > 630-980-8461**** > > [email protected]**** > > *From:* [email protected] [mailto:[email protected]] *On Behalf Of *William > Stacy > *Sent:* Monday, April 09, 2012 12:52 PM > *To:* RBASE-L Mailing List > *Subject:* [RBASE-L] - Re: IF Like**** > > ** ** > > But one problem could occur if the vendor name doubles as a last name > field, which is the special case of a two letter last name. At least in my > database I've got lots of 2 character last names (Yu, Lu, Ng, etc)**** > > On Mon, Apr 9, 2012 at 10:20 AM, William Stacy <[email protected]> > wrote:**** > > try '__' **** > > ** ** > > On Mon, Apr 9, 2012 at 10:02 AM, Dick Fey <[email protected]> > wrote:**** > > Guess my old brain is getting fuzzy. > > We use 2 letter codes for vendors (PH, QN,) etc. > > I want to call a specific vendors form if 2 letters are entered, search > the whole table if more than 2 letters > > Why does this code not work? > > IF vvennum LIKE 'AA' THEN > > IF vvennum LIKE '**' THEN > > IF vvennum LIKE '??' THEN > > IF vvennum between 'AA' and 'ZZ' THEN > > None will call a specific vendor, it always goes on to the else, which > calls all vendors having those letters in the name > > > > Old Fuzzy Brain, > > Dick Fey > > **** > > > > **** > > -- > William Stacy, O.D. > > Please visit my website by clicking on : > > http://www.folsomeye.net > > > **** > > > > > -- > William Stacy, O.D. > > Please visit my website by clicking on : > > http://www.folsomeye.net > > > **** > -- William Stacy, O.D. Please visit my website by clicking on : http://www.folsomeye.net
