>>Another, more serious, use would be to trigger the equivalent of a PACK when greater than a certain # or certain % of all records were DELETED().
>>
>>
LOCAL nDeletedCount
>>Select (cSomeAlias)
>>COUNT TO nDeletedCount FOR DELETED()
>>IF nDeletedCount > nSomeTriggerValue
>> * TIme to PACK the donuts...
>
>That's a pretty good idea -- I don't have immediate use for it, but I'll file it away for future reference...the percent idea makes the better sense, I think.
Just substitute (nDeletedCount/RECCOUNT(cSomeAlias)) and use a value between 0 and 1 for nSomeTriggerValue - given who you work for, I think you could work it out for yourself, though!