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]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
