Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combining 2 SKUs
Message
From
19/07/2002 20:23:47
 
 
To
19/07/2002 14:20:36
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00680493
Message ID:
00680698
Views:
23
If you want to sum, you can do a SQL SELECT to get the sum and unique rows:
Select SKU, ITEM, COLOR, SUM(LOCATION1) AS LOCATION1, SUM(LOCATION2) AS LOCATION2, SUM(LOCATION3) AS LOCATION3 ;
From SKUTABLE ;
Group By SKU, ITEM, COLOR ;
Into Cursor QSKU

Note: I don't know what SKU is, but if this is a quantity, you can sum it too or something like that
After run the query, you can delete all records on SKUTABLE and append from the cursor.

Well just an Idea.
If this come from 2 or more tables, you can do a UNION in the SQL Select

Mauricio
Be fast like the Fox
Be free like the Penguin
Se Rápido como el Zorro
Se libre como el Pingüino
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform