Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with Gather
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Problem with Gather
Divers
Thread ID:
00005062
Message ID:
00005062
Vues:
70
I am having trouble with the following code snippet:
SELECT  SUM(Tmpsystems.anaports), SUM(Tmpsystems.stddigports),;
  SUM(Tmpsystems.eurdigports), SUM(Tmpsystems.totdigports),;
  SUM(Tmpsystems.totports), SUM(Tmpsystems.faxports),;
  SUM(Tmpsystems.lim1), SUM(Tmpsystems.lim2), SUM(Tmpsystems.lim3),;
  SUM(Tmpsystems.lim4), SUM(Tmpsystems.lic1), SUM(Tmpsystems.lic2),;
  SUM(Tmpsystems.lic3), SUM(Tmpsystems.lic4), SUM(Tmpsystems.boxes);
 FROM quotebuilder!tmpsystems;
 Into Array laNumTotals
For x = 1 to 21
	lnSWProd3_486[x] = Alltrim(Str(gaSWProd386[x])) + " - " + Alltrim(Str(gaSWProd486[x]))
EndFor
Select sumSystem
Gather From lnSWProd3_486 Fields Like SW*
Select sumSystem
Seek 999
Gather From laNumTotals Fields AnaPorts, StdDigPorts, EurDigPorts, TotDigPorts, TotPorts, FaxPorts,;
	Lim1, Lim2, Lim3, Lim4, Lic1, Lic2, Lic3, Lic4, Boxes, StorageHours
Select tmpSystems
The Problem is that in the final Gather the fields StdDigPorts, EurDigPorts, and TotDigPorts gather to the last record of tmpSystems instead of sumSystem. This is baffling since everything else gets properly gathered to sumSystem. Any words of advice?

Thanks,
John Morrison
"Not everything that counts can be counted,
and not everything that can be counted counts"
-A. Einstein
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform