Ed Leafe wrote: > 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. > >
...but your example was where you selected your results into a single letter cursor....that's not the same as referencing an alias with a single letter in the FROM section of the SQL. -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ 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.
