Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiuser Grid
Message
From
19/03/2002 13:25:10
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00634522
Message ID:
00634561
Views:
18
>Cetin,
>I tried implementing an error handler. But VFP ignores the handler, says that the record is in use by another, and I when I press either cancel or ignore, the application ends. This happens when the second user attempts an edit of the field that the first user is editing. I tried setting readonly to true and that didn't work. I hate to abandon the grid interface for editing, but can't seem to stop the application from exiting. But thanks for you help.

Don,
Editing directly in grid is hard. However if you'd do it :
-Use either pessimistic buffering or optimistic with manual record locking
-With pessimistic buffering form's error event would handle it. ie:
if nError=109
messagebox('Currently being edited elsewhere. Try later')
return
endif

-With optimistic you'd be responsible to check that during manual locking or if didn't lock at all when tableupdating check conflicts.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform