Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Gather
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Problem with Gather
Miscellaneous
Thread ID:
00005062
Message ID:
00005062
Views:
73
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
Next
Reply
Map
View

Click here to load this message in the networking platform