Great thanks, will do a bit more reading. I'm not sure what advanced DB settings BAS even has for this kind of thing. TBH I will probably just create a work around and start using a schedule to run with 1 thread regularly until a condition is met. Then the DB is updated in real time and massively minimises the odds of a single row being selected by two scripts. Bit of a pain, but I can't see any options in BAS so far to implement what you're discussing! Best Regards
I have tried what the OP has tried, list functions such as get index and list contains aren't working as expected, it doesn't let you search the whole database for a string(it returns false / no result) nor select records by criteria.
Use the filter in the "Select Records By Criteria" action
a368082a-159a-418d-899e-adecf8b1887d-изображение.png
Your threading issues get me so curious! You'll need to start sending your projects(s) into @Fox or @support so they can dissect the code to find the cause of these effects bud.
@allister Hi, this is bug, it happens only if update column of int type. It was fixed, new version will be available in Thursday(8 November), if it is urgent for you, I can make a separate build.