Sync Data - Call Operation (Magic xpa 3.x)
The Sync Data property lets you control the order of the execution of Data Manipulation statements.
Normally, Data Manipulation statements (such as insert, update, or delete) were sent according to the Record Suffix order.
That means that if, for example, a parent task calls to a child task, then the child task completes its processing and then returns to the parent task, which also completes its processing. Since the child task ended before the parent task, Magic xpa processes the Record Suffix operations of the child task before the Record Suffix operations of the parent task, even though changes to the parent task were made prior to calling the child task.
You can change this behavior by using the Sync Data property as follows:
-
Value of Yes – Sends the parent task’s Data Manipulation statements before the child task’s Data Manipulation statements.
-
Value of No – Lets Magic xpa control the order of the execution of Data Manipulation statements.
You can also define a logical expression that can be evaluated as Yes or No.
This property is enabled for Call Task, Call Program, Call Exp, and Call Public operations at the Record, Control, and Event levels. This property is enabled for Deferred, Nested Deferred, and Within Active Transaction modes.
Limitations:
This property is disabled in the Main Program.
This property is not supported for local data sources.
How Do I Implement a One-to-Many Relationship in Magic xpa When There Is a Database Constraint?
The Online and Rich Client Samples projects (program SQ03 and RSQ03)
