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