Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RLOCK() with views??
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
RLOCK() with views??
Miscellaneous
Thread ID:
00125978
Message ID:
00125978
Views:
73
The locking strategy my users want is that if they choose to modify a record already being modified to display a message and disallow editting. The approach I took with my first couple of apps, which access the tables directly, was to use:
IF RLOCK()
    editing code goes here
ELSE
    message box saying record already being editted by someone else
ENDIF
The project I'm working on now has tables that will contain a lot of project related data for all ongoing projects so parameratized views, based on project number, are being used. I need a good record locking strategy to do exactly as above except with views. Any ideas? TIA
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Next
Reply
Map
View

Click here to load this message in the networking platform