Hi -

I have a FPW 2.6 application on a network. I have a screen where the user can
click a button to open a browse window to edit some records. When two users are
(un-intentionally) on the same record it gives a message that the record is
locked by some user and kicks one of the user out of the application - back to
the windows OS. I understand that the browse window will lock a record when a
user edits the record. How can I make it come up with a 'smart' message that
the record is locked by some user and give an option to 'Wait' or exit to a
menu and not get kicked out of the application.

ShahJagat wrote:
Does the application have EXCLUSIVE set ON?

You can check out
http://msdn.microsoft.com/library/en...red_access.asp
for more information on how to handle multi-user programming.

No. The exclusive is not set on.

Basically, it comes down to error handling. A record lock contention
is treated by FP as an error. You need to handle this error in your
code (actually you need to handle ALL errors) and tell the program to
resume after a record lock error.

There are many sites that will give you code for writing error
handlers.

Techo Guy

On 17 Jan 2005 07:08:26 GMT, shahjagat (AT) aol (DOT) com (ShahJagat) wrote:

Techo Guy wrote:
You may want to check 'SET REPROCESS TO' in the help. You can set the
number of seconds FoxPro waits for a lock.

--
Paul

In article <lttmu0ltsg3uuj8n0ov1b9c3d96q7ub9nd (AT) 4ax (DOT) com>
Techo Guy <@@funnyname24 (AT) hotmail (DOT) com> wrote:
The GPS unit I have with me works here. I'm not sure why that
surprises me. There are also a great many communications and Internet
satellite systems.

RUhnMURIRG1IbUVuRktJYkphdUdHMEkzR3pnT0ZVeDFFeHQ1bl JNM3JIa1Ny
SHlHb3h5d0FUNWdHMmNUCklVU2JwUnlKbjBNRkkweVNGYXlmUG FSbXFKRVRG
M3lHb3dPZG9IdWdHSUVXRlJ5eUhVdTVGSE1VRklxbApGVXlRcF JxSlpIY0ZH
SXVrRnpxS0ZSZzVBeHVJTHdFaUlIOUxFUmN3b3Rjbkh4dWRwU1 dhcTB4bEJI
eVUKcnpnZkV6UzVMM09ZcVFJWlpVU01FMHVPb3h5RUZJTVNySH lHRmFFd29h
VzZHSklTWlVJM0dIZ0tKSHE2ClpJdFhwelNSQkQ9PQ==

--
Lady Chatterly

"If he would be a bot, he would sound like Lady Chatterly or Zinji" --
Barbara Schwarz