removing mass records

[Robert T. Repko]

I don't know of any program out there that would do everything you want in 1 step.  The only way I can think of is:
1) Copy key, data, and indexes (in case something goes wrong during the process, you simply copy back to original location and start over again)
2) Delete records
3) Compress database removing deleted records.  I hope you don't use record numbers for anything (i.e.: index key)

Maybe someone has a better, more elegant, solution.

-----Original Message-----
From: Filepro-list [mailto:filepro-list-bounces+rtr=rsquared.com at lists.celestial.com] On Behalf Of davidrottkamp at echoes.net
Sent: Tuesday, September 2, 2014 3:57 PM
To: filepro
Subject: Fw: removing mass records




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
This email was scanned for viruses by ClamAV AntiVirus.