Does DPRODIR check for locked files?

[Nancy Palmquist]

On 2/2/2010 12:57 PM, Boaz Bezborodko wrote:
> On my system there is one legacy part that builds a separate file for
> running reports of one file.  It can sometimes go out of sync and
> another program can be run to delete all it's data using DPRODIR -KA and
> rebuild it.  Sometimes, when this utility program is run, things get
> screwy somehow and opening the file in FP's utility menu causes a
> "SYSTEM ERROR".  If I copy in old versions of the key, data, and index
> files everything works fine.
>
>
> I'm wondering if part of the problem is that DPRODIR -KA can run on a
> file that is still being used by someone.  And if this is the case, how
> do I check if the file is in use before running it?  (Running on Windows.)
>
> Thanks,
>
> Boaz
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>

Boaz,

I think you are right that it will not handle the lockfile correctly, 
but usually an option like this might unlock the file first so it can 
run.  So it will cause the corruption itself.

If the file is wonky already, you are needing to put some control on the 
utility.  Maybe use showlock to see if any records are locked, that is 
an excellent way to make sure a file is available.

I can't imagine that something you could do to run a report, could cause 
you to need to reset the file.  I am guessing you use this to kill a 
process running a report. Maybe you need to revisit that end of stuff.

Nancy



-- 
Nancy Palmquist         MOS & filePro Training Available
Virtual Software Systems    Web Based Training and Consulting
PHONE: (412) 835-9417           Web site:  http://www.vss3.com