limiting browse based on login?

[John Esak]

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=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
>