Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
10 types of people
Message
De
13/10/2003 08:40:42
 
 
À
10/10/2003 15:33:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00836301
Message ID:
00838044
Vues:
37
>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform