<div> Okay, well I decided to go in another direction on this due to time constraints.</div>
<div> What I did is create a new file that mirrors the 'main' file NRdebtor</div>
<div> I copied over JUST the records for the client that wants access so just their</div>
<div> records are in this file - they will ONLY be allowed to browse their data,</div>
<div> nothing else.</div>
<div> </div>
<div> So I created a simple screen that will show just the pertinent info, etc.</div>
<div> </div>
<div> Now, what I want to do is copy over just their records in a nightly cron job</div>
<div> </div>
<div> So, to do this, what is the command to delete all the records (except 1 blank)</div>
<div> from this new "mirror" file that has only this clients data in it?</div>
<div> I know how to get the records copied from the main file, but am unsure how to</div>
<div> delete these records before copying over a 'fresh' version - hope that makes </div>
<div> sense. I suspect it will be ddir or something to delete the records before I</div>
<div> re-copy them, is that correct?</div>
<div> </div>
<div> Thanks for all the help - but using every form of "drop" and "drop all" still just</div>
<div> takes too long since filePro apparently has to search each individual record,</div>
<div> even if using an index based on unique account number, since there are over</div>
<div> 1/2 million records it's just not a good solution at this point - this other</div>
<div> 'solution' involves probably a little more heavy lifting than might be necessary</div>
<div> but it does the trick.</div>
<div> </div>
<div> I am currently writing the @menu portion so the client will only be able to hit</div>
<div> 'V' to view and 'X' to exit, etc.</div>
<div> </div>
<div> Thanks again</div>
<div> </div>
<div> Scott</div>
<div><br><br> </div>
<div class="gmail_quote">On Thu, Sep 3, 2009 at 7:29 PM, Ken Cole <span dir="ltr"><<a href="mailto:ken.m.cole@gmail.com">ken.m.cole@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Tom,
<div class="im"><br><br>
<div class="gmail_quote">
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">Browse processing is great for a many things<br>including dropping records, but as you know, not so when it comes to<br>
dropping lots and lots of records.... because it's reading every record<br>and making a drop decision vs using an index.<br></blockquote></div><br></div>I have always found the "drop all before" and "drop all after" work extremely well and stops filePro from checking any more records which is why I wasn't sure why the original request wasn't done in a browse on the original data file using both these commands. It makes this sort of functionality simple, quick and clean.<br>
<font color="#888888"><br>Ken<br></font><br>_______________________________________________<br>Filepro-list mailing list<br><a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br><a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
<br></blockquote></div><br>