>>PACK and ZAP reindex the table anyway. You may not notice it on ZAP because RECCOUNT() is 0, however when you PACK a indexed table SET TALK ON and you'll be able to see the reindex count.
>>
>Okay, thanks. Somehow I had learned to reindex way back in FPD, and have never looked into it since.
Generally, I include a 'ReIndex' function in all my systems (unless there is no one I trust in the user area), and tell them to run it once a month. Depending on the requirements of the system, the reindex function may or may not give them the option to Pack or just ReIndex.
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place