Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select statement assumes 'AS' clause
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00953748
Message ID:
00953835
Views:
14
>A cursor was created where values were selected from fld3 and column was labeled as fld4. Hence did cause considerable confusion.
>
>How long has the assumed 'AS' column name clause been working this way?


Ronald,

This isn't just specific to VFP. "AS" is optional as well when issuing a SELECT against SQL Server data (I think Oracle as well).

Guess it just means you have to keep an eye out for those missing commas. ;)

Laterness,
Jon
Jon Rosenbaum
Devcon Drummer
Previous
Reply
Map
View

Click here to load this message in the networking platform