Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is this a BUG or?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00948418
Message ID:
00948424
Views:
18
This message has been marked as the solution to the initial question of the thread.
No it's not a bug. As you know, you can assign alias to a field in the select. The 'AS' keyword is optionnal in such case. IOW
..., Level4; && Here I missed comma after last field
                      Br1, ... 
* is the same as 
..., Level4 AS  Br1, ... 
>I have mistyped SQL statement
>
>
>
>   SELECT KStr, KDlj, Individ, Level1, Level2, Level3, Level4; && Here I missed comma after last field
>                      Br1, Br2, Br3, Br4, Br5, Br6, Br7, Br8, Br9, Br10, Br11, Br12,;
>                      PlanDlj.Kod AS OldKod, 0000000000 AS NewKod, 0000000000 AS NewStr;
>                      FROM PlanDlj;
>                      LEFT JOIN PlanStr ON PlanDlj.KStr == PlanStr.Kod;
>                      WHERE PlanStr.Scenario == kodSc;
>                      INTO CURSOR cDlj READWRITE
>
>
>The result is All fields are full except Br1. VFP don't raise an error. VFP 8 SP 1.
>
>When I set the comma on the right place everythink is OK.
>So my question is this a BUG or No? ( I think it is)
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform