Question

[abelardomiranda]

Hi, I got a doubt and I hope somebody can help me, I need to know how many recordsare in a table, actually I run a FOR EACH for the table and get a variable integer increasing 1 by 1 so I display that variable, but, ¿exist any other way to do that? thanks for your help

 

[RealHeavyDude]

SELECT COUNT(*) FROM myTable will work in the procedure editor since SQL89 syntax is supported by it.

AFAIK, you could also use this at runtime - I had a working example in the past but somehow I can't find it right now.

But, since Progress does not have something like statistics on the 4GL engine it will always result in a table scan.

The proutil <db-name> -C tabanalys > myLogFile.log will list each table and how many records are in the table - but you need to parse it.


HTH, RealHeavyDude.

 

[warrenspeicher0]

Just keep on trail and error process until you will get the answer to ur question....... patience is a virtue