General information
Category:
Coding, syntax & commands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only