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.comNever mistake having a career with having a life.