ccornagg
Well Known Member
Hi forum,
in a custom "Power Edit Form" (see OK button under transaction) I'm succesfully using standard BSFN B4200450.AdvancedSODetailLineSplit which is splitting an existing F4211 line.
For example: I'm assigning lot A, B and C to a single F4211 line with quantity 3.
While doing this kind of exercise (it's a while statement looping a specific cache) I also need to perform a fetch and an update tableIO statement hitting the same F4211 record just created by B4200450 BSFN in transaction (for example: line 1.010 not yet committed to the database).
I spent a lot of time trying with table IO using TBLE object, BSVW object, using "open handle statement" ... and so fort.
It appears JDE is using a different "transaction boundary" compared with the other BSFN in the same piece of code (OK event), thus I did not manage to have it working.
Finally I did manage to succeed by simply running the same fetch and update tableIO statements in a custom NER executed with "transaction flag" within my custom form.
Is there an explanation for that ?
Do you know about special rules to be used to run tableIO in transaction within APPL events ?
I also noticed within UBEs you have the freedom to decide when to execute a specific system fuction to commit or rollback your transaction.
I did not notice the same flexibility with APPL objects (but indeed there's an interesting "Post Commit" event really useful for F41021WF table management).
Thanks,
Carlo
TR 9.2.7.3
in a custom "Power Edit Form" (see OK button under transaction) I'm succesfully using standard BSFN B4200450.AdvancedSODetailLineSplit which is splitting an existing F4211 line.
For example: I'm assigning lot A, B and C to a single F4211 line with quantity 3.
While doing this kind of exercise (it's a while statement looping a specific cache) I also need to perform a fetch and an update tableIO statement hitting the same F4211 record just created by B4200450 BSFN in transaction (for example: line 1.010 not yet committed to the database).
I spent a lot of time trying with table IO using TBLE object, BSVW object, using "open handle statement" ... and so fort.
It appears JDE is using a different "transaction boundary" compared with the other BSFN in the same piece of code (OK event), thus I did not manage to have it working.
Finally I did manage to succeed by simply running the same fetch and update tableIO statements in a custom NER executed with "transaction flag" within my custom form.
Is there an explanation for that ?
Do you know about special rules to be used to run tableIO in transaction within APPL events ?
I also noticed within UBEs you have the freedom to decide when to execute a specific system fuction to commit or rollback your transaction.
I did not notice the same flexibility with APPL objects (but indeed there's an interesting "Post Commit" event really useful for F41021WF table management).
Thanks,
Carlo
TR 9.2.7.3