limiting browse based on login?

[Boaz Bezborodko]

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