Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help ! - Mutli User Access (VFP 3.0)
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00036773
Message ID:
00037067
Views:
32
>Have you checked-out the GETFLDSTATE(), CURVAL(), and OLDVAL() functions?
>
>Joe
>
>>I have an application that currently uses Pess. Row Buffering. The problem is in the following situation : User A and User B access/read a client record at the same time. User A then locks the record while making changes. User A TABLEUPDATES() and commits the changes. In the meantime User B answered his/her phone and currently has the original record on thier screen. They proceed to modify. When they click on an object ( in this case a popup) before it drops down I (User B) sees a status bar message saying the record has been modified by another user. I guess my two questions are: Can I intercept that message somewhere in code and give he user a proper message? or What is the least coding intensive approach to solving the situation ? The record being modifed has 75 fields display on multiple pageframes. I hoping putting code in the click or When methods of each is not the easist solution.
>>
>>Any advice would greatly appreciated.
>>
>>Thanks
>>
>>
>>
>>Scott K
Hi guys, even that I use "Buffering", what
I do is lock the record before letting the user to make
any changes, like in the old days:

IF RLOCK()
* Call code to edit record
=TABLEUPDATE(.t.)
UNLOCK
ELSE
*=messagebox("Record is in use by another, try later.")
ENDIF
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform