<HTML><HEAD>
<META content="text/html; charset=ISO-8859-1" http-equiv=Content-Type></HEAD>
<BODY dir=ltr bgColor=#ffffff text=#000000>
<DIV dir=ltr>
<DIV style="FONT-SIZE: 14pt; FONT-FAMILY: 'Calibri'; COLOR: #008000">
<DIV><FONT size=4></FONT> </DIV>
<DIV
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'><FONT
face=Arial><BR></FONT>
<DIV class=moz-cite-prefix><FONT size=4>Hi</FONT></DIV>
<BLOCKQUOTE cite=mid:0EACC8AF2BBE4B8E96BA5EEEE9A8C231@daveHP type="cite">
<DIV dir=ltr>
<DIV style="FONT-SIZE: 14pt; FONT-FAMILY: 'Calibri'; COLOR: #008000">
<DIV> </DIV>
<DIV><FONT size=4>I wanted to ask what is the best way to remove mass records
from a database</FONT></DIV>
<DIV><FONT size=4>in older version filepro, index would break down and process
would hang.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=4>I want to make a routine that would delete records based on
age, without having to </FONT></DIV>
<DIV><FONT size=4>1) remove indexes</FONT></DIV>
<DIV><FONT size=4>2) select records (which than takes forever)</FONT></DIV>
<DIV><FONT size=4>3) remove records</FONT></DIV>
<DIV><FONT size=4>4) copy back indexes and rebuild them</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=4>as this leaves blanks in the file</FONT></DIV>
<DIV><FONT size=4>I have also in past used to </FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=4>1) copy good records to qualified key</FONT></DIV>
<DIV><FONT size=4>2) copy qualified key over key</FONT></DIV>
<DIV><FONT size=4>3) rebuild indexes</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=4>problem is if this breaks in the middle I could have a
corrupt key file with very few records</FONT></DIV>
<DIV><FONT size=4></FONT> </DIV>
<DIV><FONT size=4>does any one have a better way of deleting mass records and
not leaving blanks in the file</FONT></DIV>
<DIV><FONT size=4></FONT> </DIV>
<DIV> </DIV>
<DIV
style="FONT-SIZE: 14pt; FONT-FAMILY: 'Calibri'; COLOR: #008000">Thanks,<BR><BR>Dave
Rottkamp <BR>Cell 570-620-8027<BR><BR><A class=moz-txt-link-abbreviated
href="http://www.poconolakeproperties.com">www.poconolakeproperties.com</A></DIV></DIV></DIV></BLOCKQUOTE><BR><BR><BR>
<HR
style="BORDER-TOP: medium none; HEIGHT: 1px; BORDER-RIGHT: medium none; WIDTH: 99%; BORDER-BOTTOM: medium none; COLOR: #909090; BORDER-LEFT: medium none; BACKGROUND-COLOR: #b0b0b0">
<TABLE
style="BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-COLLAPSE: collapse; BORDER-BOTTOM: medium none; COLOR: #000000; BORDER-LEFT: medium none">
<TBODY>
<TR>
<TD
style="BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; PADDING-LEFT: 8px; BORDER-LEFT: medium none; PADDING-RIGHT: 15px"><A
href="http://www.avast.com/"><IMG border=0
src="http://static.avast.com/emails/avast-mail-stamp.png"> </A></TD>
<TD>
<P
style='FONT-SIZE: 12pt; FONT-FAMILY: "Calibri","Verdana","Arial","Helvetica"; COLOR: #3d4d5a'>This
email is free from viruses and malware because <A
href="http://www.avast.com/">avast! Antivirus</A> protection is active.
</P></TD></TR></TBODY></TABLE><BR></DIV></DIV></DIV></BODY></HTML>