<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 href="mailto:john@valar.com">john@valar.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">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></div>
<div class="h5"><br><br><br>> -----Original Message-----<br>> From: filepro-list-bounces+john=<a href="http://valar.com/" target="_blank">valar.com</a>@<a href="http://lists.celestial.com/" target="_blank">lists.celestial.com</a><br>
> [mailto:<a href="mailto:filepro-list-bounces%2Bjohn">filepro-list-bounces+john</a>=<a href="http://valar.com/" target="_blank">valar.com</a>@<a 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 href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>; <a 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 href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>" <<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>><br>
> > Subject: Re: limiting browse based on login?<br>> > To: Ken Cole <<a href="mailto:ken.m.cole@gmail.com">ken.m.cole@gmail.com</a>>, filePro Mailing List<br>> > <<a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>><br>
> > Message-ID:<br>> > <<a 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></div>
<div class="h5">> _______________________________________________<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><br></div></div></blockquote></div><br>