Aug 17th, 2000, 04:04 AM
Hi Kovan,
I'm not sure why each of your users must access a different table but you could try something like this.
Why not setup another table in your data base called TableLocks, with two fields, Username and TableName.
Create a record in this file for each of your tables.
When ever a user attempts to access a table1, check the TableLocks table and see if anyother user is accessing
table1 (i.e. Check the username field).
If not write the users name to the Username field.
When the user is finished with table1 clear the Username field.
You will have to cater for unexpected shutdowns(abends) such as Ctrl-Alt-Del, power out, etc.
I hope this is of some use
Sean.
I'm not sure why each of your users must access a different table but you could try something like this.
Why not setup another table in your data base called TableLocks, with two fields, Username and TableName.
Create a record in this file for each of your tables.
When ever a user attempts to access a table1, check the TableLocks table and see if anyother user is accessing
table1 (i.e. Check the username field).
If not write the users name to the Username field.
When the user is finished with table1 clear the Username field.
You will have to cater for unexpected shutdowns(abends) such as Ctrl-Alt-Del, power out, etc.
I hope this is of some use
Sean.