Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Order By?
Message
 
To
23/12/1999 10:35:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00307929
Message ID:
00307968
Views:
17
select data1.bundle+data2.bundles+data3.bundle+data4.bundles+data5.bundle+data6.bundle+data7.bundle+data8.bundle;
as acBundle2;
from data1, data2,data3,data4,data5,data6,data7,data8 ;
where data1.grade + data1.siz + data1.length = data2.grade + data2.siz + data2.length;
and data2.grade + data2.siz + data2.length = data3.grade + data3.siz + data3.length;
and data3.grade + data3.siz + data4.length = data4.grade + data4.siz + data4.length;
and data4.grade + data4.siz + data4.length = data5.grade + data5.siz + data5.length;
and data5.grade + data5.siz + data5.length = data6.grade + data6.siz + data6.length;
and data6.grade + data6.siz + data6.length = data7.grade + data7.siz + data7.length;
and data7.grade + data7.siz + data7.length = data8.grade + data8.siz + data8.length;
and data1.grade = gdValue and data1.siz = szValue and data1.length = 2 ;
order by 2 ;
into cursor myCursor
There is no second field in the fields list.

Did you mean to get a cursor with one field containing the concatenation of all the other fields? If not then change the +'s to ,'s in teh field list.
Previous
Reply
Map
View

Click here to load this message in the networking platform