Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Undetected error
Message
 
 
To
13/08/2001 08:15:41
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00542929
Message ID:
00542945
Views:
14
This message has been marked as the solution to the initial question of the thread.
Hilmar,
This behavior is by design. AS clause isn't requred to assign a field new name. It's the same as
select article, artcode <b>AS</b> artname from ArticleMain
>VFP6, SP5
>
>The following command has an error (missing comma):
>
>select article, artcode artname;
>	from ArticleMain
>
>However, Visual FoxPro doesn't complain, either at compile time or at runtime!
>It does omit the second field. I have wasted hours debugging, due to this missing comma (this usually happens to me at the end of the line, before the ";").
>
>Is this a feature of all versions of Visual FoxPro? I think I remember the error was caught in FoxPro 2.6.
>
>Hilmar.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform