Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help ! - Mutli User Access (VFP 3.0)
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00036773
Message ID:
00037067
Vues:
30
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform