Empty Temp-table

[RealHeavyDude]

Out of experience I can tell that most Progress shops (at least the ones I know) don't invest in their developers. In other words they are not willing to pay for trainings when they introduce a new Progress/OpenEdge version. That means, that many developers, unless they stumble over a new feature by chance or have been informed by a "more" knowledgeable fellow developer at their disposal, are stuck with whatever knowledge they have in whatever version they happened to learn Progress.

One thing Progress has always claimed to be an advantage of the ABL is, that the language hides the complexity of technology from the developers so that they can concentrate on the business domain know how. While that may have been true at the beginning of the 1990s, in today's wold it is not sufficient any more. But that's another discussion.

Heavy Regards, RealHeavyDude.

 

[rzr]

from the documentation...

When you empty a temp-table that is defined as UNDO within a transaction, the ABL Virtual Machine (AVM) deletes the records individually. This is less efficient than emptying the temp-table outside the transaction, where the AVM deletes all records in the temp-table as a unit.