Interactive Application Fail to Update Table After Alter Table
Hi Experts,
I've created an Interactive Application with EDIT button. This application using V554252A (F4211/F5542520)
Column for left join 92 between F4211 and F5542520 is DOCO, LNID and DCTO
Normally, when users click the EDIT button, ER logic will check is there a record exist in F5542520
If not exist, ER logic will insert into F5542520, else update the existing data as below :
// Check F5542520 by SO VA frm_PickNoInt = 0 F5542520.Fetch Single VA frm_StatusStr = "OPEN" If VA frm_PickNoInt is equal to <Zero> // New Get Next Unique Key ID F5542520.Insert Else // Edit F5542520.Update End If