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