Function reindex as boolean
Local llResult as boolean
Try
Open database bleh excl
Use mytable
Reindex
llResult =.t.
Catch to loEx
? 'Sorry,' + loEx.message
Finally
Close database bleh
Endtry
Return llResult
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
On Tue, 23 Jul 2019, at 5:36 PM, Ken McGinnis wrote:
> We have a vfp9 SP2 program that has been running nearly bug free for
> over 10 years. Only now we have a need to find out if anyone else is
> using the exe in a specific folder. We allow many users to have their
> own unique folder with their patient data files.
>
> So we log into folder 1 and another user is in folder 2. No problem.
>
> If we log into folder 1 and another user is in that same folder, again
> no problem. Our software is multi-user down to the individual record
> level. The problem is when the 2nd user comes in and needs to lock many
> or all files to reindex or other procedures. How can the 2nd user know
> that another user is there? Again it is not a problem until that 1st
> user starts to do something, almost anything that requires accessing
> files. All files are locked by the 2nd user so the 1st user starts
> getting errors.
>
> We could try to lock the exe and that would fail so we would know
> someone else is using the software. However, if that other user is
> working with data in a different folder, we don't care so we do not want
> to lock the exe.
>
> Hope that is clear
>
>
>
> >
> >
> >
[excessive quoting removed by server]