Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select with additional conditions
Message
 
 
À
14/11/2007 20:34:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01268865
Message ID:
01269107
Vues:
12
>I think using one-letter aliases is a matter of taste as far as readability goes. I use them all the time.

Hi Al,

I have no objections to one leter table aliases unless they are VFP reserved words. The 'one leter meaningless table aliases' are different story. Using them in a query is the same as using following proceduaral code (yes I've seen such code in real life)
SELECT A
USE mytable1
SELECT B
USE mytable2
...
* Somehwere later
SELECT B     && At this point it's impossible to tell what table code is refering to w/o going back and finding USE command.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform