[stackoverflow] [progress Openedge Abl] Progress 4gl How Count The Number Of Rows In A Table

http://knowledgebase.progress.com/articles/Article/P5496

I have tried For Each tableA no-lock with i integer increment. I also tried accum. but I get no luck. The reason I think is because the table is really large.

for the accum. how can I benefit from the index if I have multiple field as the key?.

Here is the data sample.

Table name is tableA the key index is trxNum, CtrlNum, SeqNum

I tried to enter the key index this way. But I think is not a valid syntax:

FOR EACH trxCtld NO-LOCK:
ACCUMULATE trxNum, CtrlNum, SeqNum (COUNT).
END.


and what would be the trick to so show progress, as in how many times the loop is done. I was thinking it would be nice to show every 10000 loop to pop up a message saying "hey I have done 10000 loop" and so on...

thank you

I am guesstimating tableA has about 2 million records.

Continue reading...