What I have:
several textboxes on a screen(not a form).
The textboxes get their Default value from a datatable.. i.e. tbl_SkuDetail_1.Selected.SKU
If a person makes a change to a textbox, i need to preserve this previous value and then also record the new value that has been changed.
here is my my Patch code for the OnChange event Function.
Patch('[dbo].[t_redbook_pricing_escalation_ChangeLog_Detail]',Defaults('[dbo].[t_redbook_pricing_escalation_ChangeLog_Detail]'),
{
RBP_MASTER_ID: Value(RBK_EscalationId_txt.Text),
FIELD_CHANGED: RBK_Sku_txt.Text,
OLD_VALUE: Value(RBK_Qty_txt.Text),
NEW_VALUE: RBK_Description_txt.Text,
CHANGED_BY_RACFID: txt_QS_RACFID.Text,
CHANGED_BY_NAME: User().FullName,
CHANGED_BY_DATE: Now()
}
)
Thanks
Dave
