Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is this a BUG or?
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Is this a BUG or?
Miscellaneous
Thread ID:
00948418
Message ID:
00948418
Views:
64
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)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Next
Reply
Map
View

Click here to load this message in the networking platform