Data Race Conditions

Question

In a QB Channel -- I seem to be experiencing a race condition

From a staging table:
1. [Thread 1] System checks to see if order A exists in the sales table. Does not find Order A
2. [Thread 2] System checks to see if order A exists in the sales table. Does not find Order A
3. System creates Order A
4. System creates Order A

Where what should be happening is step 3 moves up to step 2.

Any ideas on throttling or flagging?

------------------------------
Malcolm McDonald
------------------------------

MarkShnierYou · Answer

Is the situation that you are mass creating or importing children and you want to make Parents when required? Is the parent getting duplicated? can there be a custom Key field for the parent so it can't get duplicated? ie does the trigger know what the Key field of the Parent Order should be?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community