How to pass or set dynamic value in BMQL update query

Summary

How to pass or set dynamic value in BMQL update query

Content

Dear All,

 

We are trying to update a record in a table using BMQL and trying to set the dynamic value to one column  

get the error while executing the BML code

 

Please check the below code

 

eff_date = datetostr(strtojavadate(effectiveDate_t, "MM/dd/yyyy h:mm a"), "MM/dd/yyyy");

set1 = "end_date=$eff_date"; 

partyCode = distributorPartyCode_t;

for each in transactionLine

{

partnum = each._part_number;

print partnum;

results = bmql("update Party_Part_Price set $set1 where part_number = $partnum and party_code = $partyCode");

print results;