cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

A way of accounting for concurrency when accessing a data-table?!

Michail
9-Granite

A way of accounting for concurrency when accessing a data-table?!

In my application multiple users can access/make records in the same data-table around the same time. The challenge here is to increment the unique id correctly which is just a simple order number [primary key]. I've solved the problem by using a Boolean flag property which changes state whenever the data-table is in use. With Boolean flag in new state, another user would have to wait a millisecond and receive a notification after a failed attempt to create a record. Would that be considered a normal practice? Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
PaiChung
22-Sapphire I
(To:Michail)

some flag to track if a record is in edit I indeed standard practice.

View solution in original post

1 REPLY 1
PaiChung
22-Sapphire I
(To:Michail)

some flag to track if a record is in edit I indeed standard practice.

Top Tags