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:
00953755
Views:
14
At least from VFP5.

>Trying to debug code, came across a select statement that was missing a comma to separate fields like the following
>
>Select fld1, fld2, fld3 ;
> fld4, fld5 from cTable into cursor myCursor
>
>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?
Previous
Reply
Map
View

Click here to load this message in the networking platform