Problem in Dynamic Updates

Thu, 21 Nov 2013 06:42:05 GMT

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?

topic Problem in Dynamic Updates in QlikView

Problem in Dynamic Updates