>>>>But now that you bring it to *our* attention, in sql-selects I use single-letter aliases a lot and it has never harmed me in any way. The sql-select code is always in its entirety visible on the screen and the interpretation is easy enough. Moreover, a letter is neutral and allows changing the name of the used table more easily; in other cases the name of the used table is even unknown when programming.
>>>>
>>>>We've had some discussions on standards recently, as you probably know. I think that your statement is debateable. Perhaps this reaction is the offset for that debate. :)
>>>
>>>Peter;
>>>
>>>This may never happened to you but I know of several people who used A-J for an alias and it caused problems. This is something that goes back to dBase and could still be an issue. I have not tested it for some time but I never use a one letter alias - it is force of habit.
>>>
>>Tom,
>>
>>While using a single letter alias may not be a problem with either an SQL SP or when using SPT, using it in Fox is a terrible idea. This practice ties the code to a specific work area. Further, if a table is already in use in that work area, it is automatically closed.
>>
>>Of course, you know all this.:-)
>
>Hello George and Happy Friday!

Happy Friday to you, too, Tom.

>Life was so much simpler with dBase II with only two work areas. :)

< vbg >

>By the way the Unos Pizza restaurant in Santa Clara closed. Now I guess I had better go to Chicago to get the real thing!

Aw, that's a shame. There was one in Atlanta several years ago, but that closed too. Some people just don't know good pizza.

Well, the original Uno's is better than the chain restaurants (if you can believe it). I don't know if nows a good time to go to Chicago, however. All that baseball stuff.:-)

Oh...and

Go Cubs!