Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is this a BUG or?
Message
From
04/10/2004 08:19:37
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00948418
Message ID:
00948422
Views:
13
Hi,

Are you sure you aren't seeing the contents of Level4 in a column named Br1 ?

Regards,
Viv

>>
   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.
>>
Previous
Reply
Map
View

Click here to load this message in the networking platform