Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select with additional conditions
Message
 
 
To
14/11/2007 20:34:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01268865
Message ID:
01269107
Views:
11
>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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform