Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
10 types of people
Message
From
13/10/2003 08:40:42
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00836301
Message ID:
00838044
Views:
41
>>>The letter A was used in a sql-select. Let me PINS (reverse of SNIP) it here once more:
>>>
select distinct ttod( a.from ) from ( lcFile ) a into array laTmp
>>>Tamar was referring to this usage. For the sake of the eventual discussion, let's limit the debate to whether or not it's 'allowed' (according to the idea of 'superb standards') in sql-select statements. The arguments you both gave against usage are not valid for usage in sql-selects, IMO.
>>
>>This is exactly the usage that can get you in trouble. If you have a table already open in workarea 1, there can be confusion as to what a. refers to in the query.
>
>No confusion possible ... simply because you can see the A being declared in the sql-select statement.

But if you already have a table open in workarea 1 (which is also workarea A), then there's confusion between that workarea and the one in the query.

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform