Dynamic Update Help

[Anonymous]

Hi All,

I need help with dynamic update statement where user make changes to inputbox 'Company', TempDate' or  'Value'  and reflected back on "Test" table with the updated information. Lets say i selected company 'ABC' and make changes to the value '100' to '200'. i want the '200' value to reflected on the 'Test" table.

In my current process, user select one item on "Test" table, then select "Populate Item" button.  Please see attached qvw. Any inputs will greatly appreciated!.

Thanks,

Frank

[sunny_talwar · Accepted solution]

You need to use the table name from your database:

Update Statement:

UPDATE Temp SET Value = '$(vValue)' WHERE Company='$(vCompany)';

HTH

Best,

Sunny

[Anonymous]

Thanks. It works!

Sunny- would you happen to know if the'value' field  still works with dynamic update if value numbers are base on  calculation?  such as  A+B = Value field

[sunny_talwar]

This was my first time with Dynamic Update. I am not sure if it will work or not.

But having said that, we might be able to test it out by creating two variable vValue1 and vValue2 and adding them up to see if it works

I am going to check it now

Best,

Sunny

[sunny_talwar]

This seems to work:

UPDATE Temp SET Value = '$(=$(vValue1) + $(vValue2))' WHERE Company='$(vCompany)';

[Anonymous]

Thanks.

Agree. It does works with multiple variables.  But the value field that calculated dont seems to be working with dynamic update. This value field that im using consist of  sum(A & B) where A & B has its condition to generate in the load script. I provided you a wrong situation in above message for "A+B=Value field". It should be the sum(A&B) situation.

I appreciate you looking into this.

Many Thanks,

Frank