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