Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Sun, Aug 15 2021 8:12 PM	Permanent Link
Ian Branch	Hi Team, If User A has Table A open in App A, and and User B opens App A, how can I detect if Table A is in use at this time and prevent B from running a procedure that would use Table A?? Regards & TIA, Ian
Mon, Aug 16 2021 2:18 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Ian Open it Exclusive for user A. That will stop anyone else using it until released. The only other way I know is to set a flag to control things. Roy Lambert
Tue, Aug 17 2021 7:00 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Ian, << If User A has Table A open in App A, and and User B opens App A, how can I detect if Table A is in use at this time and prevent B from running a procedure that would use Table A?? >> Roy's solution is the best. Anything else is going to involve you getting into the "locking" business with a locks table, etc. Tim Young Elevate Software www.elevatesoft.com