>>I agree with Tamar on this one. I have seen the SELECT get confused and cause extremely difficult to track down bugs in the past. Whether this is still a problem with SELECT or has been fixed, I do not know. I've simply made it my own personal rule to use at least 2 character SELECT alias' as this prevents all possible confusion with the A-J, 1-10 standard areas.
>
>Hi Fred,
>
>I have never seen the sql-select get confused (I'm in fp/vfp since 1990 or so) and I'm also certain that I'll never gonna see it happen in the future. It's just simply not true that VFP can get confused. There's only one way to convince me in this case and that is some 'code to reproduce'.
I definately saw this when FoxPro (not VFP) first implemented the SELECT statement. It caused me to lose several days sleep, so when I found that a two character alias didn't cause the problem, I lived with. It's proabably been fixed somewhere along the line. But I still remember the pain it caused. It was very real.