>>>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.
Fred, I believe you, of course. But now it's vfp7/8 ...
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
