removing mass records
Richard Kreiss
rkreiss at gccconsulting.net
Tue Sep 2 14:58:06 PDT 2014
Top post:
What version if FilePro and what OS?
Richard Kreiss
GCC Consulting
Sent from my iPhone
> On Sep 2, 2014, at 3:56 PM, <davidrottkamp at echoes.net> wrote:
>
>
>
>
> 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>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
More information about the Filepro-list
mailing list