You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to pass or set dynamic value in BMQL update query

Accepted answer
11
Views
3
Comments
edited Aug 14, 2020 12:10PM in Configure Price Quote 3 comments

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;

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!