Hi,
i'm using dynamic updates where insert 4 values into a table.
1. I created a empty inline table where values need to be insert into this table.
2. I defined few variables to store the values.
3. Create a button, apply the INSERT SQL in dynamic updates action.
Variables..3 variables created
Refer to image below..
When I click on the button, variables vTargetedTabName, vTargetedCreatedDateTime are inserted into the inline table but vTargetedCustomer no. Refer to the text field in the image below, the varible vTargetedCustomer works fine which display the customer code accordingly.
Below are the INSERT SQL Statement
INSERT INTO * (Targeted_Customer_Key, Targeted_TabName, Targeted_CreateDateTime, Targeted_Customer)
VALUES (=$(vTargetedTabName)&$(vTargetedCreatedDateTime), =$(vTargetedTabName), =$(vTargetedCreatedDateTime), =GetFieldSelections([Customer Code])))
Any one can help?