Fw: removing mass records
Robert T. Repko
rtr at rsquared.com
Tue Sep 2 21:39:45 PDT 2014
That's okay if you don't want to keep some of the system maintained fields such as @cd which copy will change to the date the data was copied.
-----Original Message-----
From: Filepro-list [mailto:filepro-list-bounces+rtr=rsquared.com at lists.celestial.com] On Behalf Of Fairlight
Sent: Tuesday, September 2, 2014 10:46 PM
To: filepro-list at lists.celestial.com
Subject: Re: Fw: removing mass records
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/20140
> 902/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.
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list
This email was scanned for viruses by ClamAV AntiVirus.
More information about the Filepro-list
mailing list