On Feb 6, 2008, at 11:43 AM, MB Software Solutions wrote:
>> The single-letter problem would happen if you did something like
>> this:
>>
>> SELECT someField ... INTO CURSOR E
>> SELECT E
>> LOCATE FOR someField = someValue
>>
>> If cursor 'E' is not in work area 5 (i.e., work area 'E'), you will
>> see the problem you describe, since 'SELECT E' is ambiguous.
>>
>>
>
> I thought you meant this was bad practice:
>
> SELECT a.name, a.age, a.sex FROM MyTable a
>
> Did I misunderstand?
What would make you think that I suggested it was a good practice? I
gave an example where using a single-letter alias would cause a problem.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
