Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Something wrong with my code
Message
From
21/09/2004 06:47:56
 
 
To
21/09/2004 06:03:26
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00944451
Message ID:
00944467
Views:
22
Does something like this will do the job?

SELECT ncli, COUNT(ncli) AS telno FROM active ;
GROUP BY 1 INTO CURSOR telno

SELECT active
INDEX ON ncli TAG descncli DESCENDING

SELECT telno
SCAN
lnncli=telno.ncli
IF SEEK(lnncli,"active","descncli")
SELECT active
REPLACE active.count2 WITH telno.telno
REPLACE active.Count1 WITH telno.telno WHILE active.ncli=lnncli
ELSE
* should be imposible but...
ENDIF
SELECT telno
ENDSCAN
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform