Zoltan_Gyimesi
Legendary Poster
Hi JDEList,
Platform: XE SP23 - SQL Database
Requirement:
In some conditions based on new TK values (and changes), I have to set a TK Field value (of course F0911
I tried it in the "Before Record is Updated" TER.
I verywell know, that not all TK is populated in TER, so I Fetched some related value into variabless in this TER - to be on the safe side.
Of course, my "idea" did not work.
After I simplified my code and made my tests from the bottom to top (as I can not debug TER), I noticed:
#1.) Tk structure is not popoulated in this TER - as primary key fields also
#2.) Assigning a value to a TK field in this TER does not update this field in the table.
Please, do not advise to use database trigger, this is not a chance now.
Q1.) Is it a very well know issue and do I give this way up? (I searcehed JDEList, but haven't found a final answer).
Q2.) Any suggestion to solve this issue in TER on our XE SP23? Maybe to place the logic onto another Table Trigger?
Thanks in advance all of your input.
Regards,
Zoltán
Platform: XE SP23 - SQL Database
Requirement:
In some conditions based on new TK values (and changes), I have to set a TK Field value (of course F0911
I tried it in the "Before Record is Updated" TER.
I verywell know, that not all TK is populated in TER, so I Fetched some related value into variabless in this TER - to be on the safe side.
Of course, my "idea" did not work.
After I simplified my code and made my tests from the bottom to top (as I can not debug TER), I noticed:
#1.) Tk structure is not popoulated in this TER - as primary key fields also
#2.) Assigning a value to a TK field in this TER does not update this field in the table.
Please, do not advise to use database trigger, this is not a chance now.
Q1.) Is it a very well know issue and do I give this way up? (I searcehed JDEList, but haven't found a final answer).
Q2.) Any suggestion to solve this issue in TER on our XE SP23? Maybe to place the logic onto another Table Trigger?
Thanks in advance all of your input.
Regards,
Zoltán