Fw: removing mass records

davidrottkamp at echoes.net davidrottkamp at echoes.net
Tue Sep 2 12:56:38 PDT 2014




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>


More information about the Filepro-list mailing list