Fw: removing mass records

Fairlight fairlite at fairlite.com
Tue Sep 2 19:45:48 PDT 2014


I'd make a duplicate file (or even just qualifier), then write a worm to go
through and just use COPY on lookups between the two, grabbing all
non-empty records.  Then move the new version into place.

m->

On Tue, Sep 02, 2014 at 03:56:38PM -0400, Dave Rottkamp thus spoke:
> 
> 
> 
> 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
> 

-- 
Audio panton, cogito singularis.


More information about the Filepro-list mailing list