Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combining 2 SKUs
Message
De
19/07/2002 20:23:47
 
 
À
19/07/2002 14:20:36
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00680493
Message ID:
00680698
Vues:
24
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform