<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Just to answer your first questions...John was commenting on the
possibility that if you called a SYSTEM command to run ddir as I
suggested, you might be doing so from within the file that you wish to
delete the existing records. The result of this is that you delete all
the records but keep the one you are standing on. My assumption was
that you would execute this from the master file before moving the data
to the new file. Under this circumstance you would delete all the
records and there wouldn't be one left over.<br>
<br>
If you are creating a new file and just using the unqualified version
of this file, then just using the -K flag will delete all the records
in that file. If you want to delete all records in all qualifiers then
you need to use -KA. If you are creating a separate qualified file for
each customer and just want to delete a specific qualifier then "-K -m
qualifier" will delete the records in just that particular qualifier.<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> wrote:
<blockquote
cite="mid:445ca8160909140828u50e78ed5o22d66d77d89e6501@mail.gmail.com"
type="cite">
<div> Sorry John, I was just uncertain of the exact flags.</div>
<div> Also, I was confused by the one blank record idea because I
was also working</div>
<div> on some import/export stuff....that's another story.</div>
<div> </div>
<div> Anyways, here is where I'm at.</div>
<div> I have everything I want setup so far...except one thing I'm
not certain of.</div>
<div> Here is my input processing on the "new" file I created.</div>
<div> Now, I'm not sure how to get the browse window keys to work.</div>
<div> You can see from my processing that I want to be able to hit
"V" to view</div>
<div> the screen 1v in this main file. I also want to be able to
hit "N" for notes and</div>
<div> "P" for payments when at this browse window.</div>
<div> I have tried using the @bk command but it doesn't do anything.</div>
<div> Keep in mind, I ONLY want them to be able to view things, NOT
change anything.</div>
<div> What am I missing here?</div>
<div> Also, when hitting "X" from this browse window, I want it to
exit completely, </div>
<div> not go to the filePro IUA menu.</div>
<div> </div>
<div> Input processing table:</div>
<div> </div>
<div> 1</div>
<div> @menu If:</div>
<div> Then: dim myiua(3)</div>
<div> 2</div>
<div> If:</div>
<div> Then: myiua["1"]="Choose Search Option"</div>
<div> 3 If:</div>
<div> Then: myiua["2"]="A:Search by Acct Num"</div>
<div> 4 If:</div>
<div> Then: myiua["3"]="B:Search by Last Name"</div>
<div> 5</div>
<div>rptmnu If:</div>
<div> Then: cls("22")</div>
<div> 6 If:</div>
<div> Then: menu myiua dosrch1, dosrch2</div>
<div> 7 If:</div>
<div> Then: exit</div>
<div> 8 If:</div>
<div>dosrch1Then: lookup act = mainfile k=3 i=A -nx b="(brw=12
xkey=x pop=1v prc=actn fill=asc,top) [ Acct Num </div>
<div> 9 If:</div>
<div> Then: Beg Bal Payments Curr Bal]
*3 *7 *20
*21 *22 "</div>
<div> </div>
<div>10 If:</div>
<div> Then: end</div>
<div> </div>
<div> 11 If: @bk="N"</div>
<div> Then: ...does a browse lookup to the notes file,
matching on Acct #</div>
<div> </div>
<div> 13 If:</div>
<div> Then: end</div>
<div>14 If:</div>
<div>dosrch2Then: ....does the same browse lookup as in line 8 &
9 above, only using a different index (for last name) and uses prc=name</div>
<div> </div>
<div> 17 If:</div>
<div>actn Then: show \r V \r to View \r N \r for Notes \r P \r
for Payments; end</div>
<div>18 If:</div>
<div>name Then: show \r V\r to View \r N \r for Notes \r P \r for
Payments; end</div>
<div> </div>
<div> </div>
<div> What am I missing here???</div>
<div> thanks</div>
<div> </div>
<div> Scott</div>
<div> </div>
<div> <br>
<br>
</div>
<div class="gmail_quote">On Fri, Sep 11, 2009 at 2:13 PM, John Esak <span
dir="ltr"><<a moz-do-not-send="true" href="mailto:john@valar.com">john@valar.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">I'm
not sure why you want to leave one blank record in the files you want to<br>
clear. The command to clear ALL records on Unix is:<br>
<br>
ddir filename -k (kill the main file only (the unqualified file))<br>
<br>
ddir filename -ka (kill all qualifiers as well)<br>
<br>
ddir filename -k -m qualifier (kill a particular qualifier)<br>
<br>
For Windows substitute dprodir for ddir.<br>
<br>
*Kill means empty the key/data and rebuild the indexes to fresh ones.<br>
<br>
But why could you not have looked this up in the manual? Or in the help
for<br>
this program in the on-line Help. F10 in Define Menus for example.<br>
<font color="#888888"><br>
John<br>
</font>
<div>
<div class="h5"><br>
<br>
<br>
> -----Original Message-----<br>
> From: filepro-list-bounces+john=<a moz-do-not-send="true"
href="http://valar.com/" target="_blank">valar.com</a>@<a
moz-do-not-send="true" href="http://lists.celestial.com/"
target="_blank">lists.celestial.com</a><br>
> [mailto:<a moz-do-not-send="true"
href="mailto:filepro-list-bounces%2Bjohn">filepro-list-bounces+john</a>=<a
moz-do-not-send="true" href="http://valar.com/" target="_blank">valar.com</a>@<a
moz-do-not-send="true" href="http://lists.celestial.co/"
target="_blank">lists.celestial.co</a><br>
m] On Behalf Of Boaz Bezborodko<br>
> Sent: Friday, September 11, 2009 10:53 AM<br>
> To: <a moz-do-not-send="true"
href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>;
<a moz-do-not-send="true" href="mailto:scooter6@gmail.com">scooter6@gmail.com</a><br>
> Subject: Re: limiting browse based on login?<br>
><br>
> ><br>
> > Date: Fri, 11 Sep 2009 10:28:14 -0400<br>
> > From: "<a moz-do-not-send="true"
href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>" <<a
moz-do-not-send="true" href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>><br>
> > Subject: Re: limiting browse based on login?<br>
> > To: Ken Cole <<a moz-do-not-send="true"
href="mailto:ken.m.cole@gmail.com">ken.m.cole@gmail.com</a>>,
filePro Mailing List<br>
> > <<a moz-do-not-send="true"
href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>><br>
> > Message-ID:<br>
> > <<a moz-do-not-send="true"
href="mailto:445ca8160909110728r2015be5cr7e1fbe2285d37347@mail.gmail.com">445ca8160909110728r2015be5cr7e1fbe2285d37347@mail.gmail.com</a>><br>
> > Content-Type: text/plain; charset="iso-8859-1"<br>
> ><br>
> > Okay, well I decided to go in another direction on<br>
> this due to time<br>
> > constraints.<br>
> > What I did is create a new file that mirrors the<br>
> 'main' file NRdebtor<br>
> > I copied over JUST the records for the client that<br>
> wants access so<br>
> > just their<br>
> > records are in this file - they will ONLY be allowed<br>
> to browse their<br>
> > data,<br>
> > nothing else.<br>
> ><br>
> > So I created a simple screen that will show just the<br>
> pertinent info,<br>
> > etc.<br>
> ><br>
> > Now, what I want to do is copy over just their<br>
> records in a nightly<br>
> > cron job<br>
> ><br>
> > So, to do this, what is the command to delete all the<br>
> records (except<br>
> > 1 blank)<br>
> > from this new "mirror" file that has only this<br>
> clients data in it?<br>
> > I know how to get the records copied from the main<br>
> file, but am unsure<br>
> > how to<br>
> > delete these records before copying over a 'fresh'<br>
> version - hope that<br>
> > makes<br>
> > sense. I suspect it will be ddir or something to<br>
> delete the records<br>
> > before I<br>
> > re-copy them, is that correct?<br>
> ><br>
> > Thanks for all the help - but using every form of<br>
> "drop" and "drop<br>
> > all" still just<br>
> > takes too long since filePro apparently has to search<br>
> each individual<br>
> > record,<br>
> > even if using an index based on unique account<br>
> number, since there are<br>
> > over<br>
> > 1/2 million records it's just not a good solution at<br>
> this point - this<br>
> > other<br>
> > 'solution' involves probably a little more heavy<br>
> lifting than might<br>
> > be necessary<br>
> > but it does the trick.<br>
> ><br>
> > I am currently writing the @menu portion so the<br>
> client will only be<br>
> > able to hit<br>
> > 'V' to view and 'X' to exit, etc.<br>
> ><br>
> > Thanks again<br>
> ><br>
> > Scott<br>
> ><br>
> You can run a SYSTEM command to run the DDIR program with flags to<br>
> delete the data before you start filling it up again.. Just<br>
> check out<br>
> the flags you can use in the manual. (I believe that -KA will
delete<br>
> all data and key elements and empty the indexes. Once this<br>
> is done you<br>
> have an empty file to work with.<br>
><br>
><br>
> Boaz<br>
</div>
</div>
<div>
<div class="h5">> _______________________________________________<br>
> Filepro-list mailing list<br>
> <a moz-do-not-send="true"
href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
> <a moz-do-not-send="true"
href="http://mailman.celestial.com/mailman/listinfo/filepro-list"
target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
><br>
<br>
</div>
</div>
</blockquote>
</div>
<br>
</blockquote>
</body>
</html>