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--