Fw: removing mass records
davidrottkamp at echoes.net
davidrottkamp at echoes.net
Tue Sep 2 12:56:38 PDT 2014
Hi
I wanted to ask what is the best way to remove mass records from a database
in older version filepro, index would break down and process would hang.
I want to make a routine that would delete records based on age, without having to
1) remove indexes
2) select records (which than takes forever)
3) remove records
4) copy back indexes and rebuild them
as this leaves blanks in the file
I have also in past used to
1) copy good records to qualified key
2) copy qualified key over key
3) rebuild indexes
problem is if this breaks in the middle I could have a corrupt key file with very few records
does any one have a better way of deleting mass records and not leaving blanks in the file
Thanks,
Dave Rottkamp
Cell 570-620-8027
www.poconolakeproperties.com
--------------------------------------------------------------------------------
This email is free from viruses and malware because avast! Antivirus protection is active.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20140902/a0a9463a/attachment.html>
More information about the Filepro-list
mailing list