BMQL Error

Content

BML Code:

 

ApprovedDisount=0.0;

if(status_t=="Approved")
{
    ApprovedDisount=totalDiscount_Header;
}
modifySet1="SPA_ID='"+transactionID_t+"'";
modifySet2="Distributor='"+distributorName_Header_Distributor+"'";
modifySet3="Requester='"+owner_t+"'";
modifySet4="RequestedDiscount='"+string(totalDiscount_Header)+"'";
modifySet5="ApprovedDisount='"+string(ApprovedDisount) +"'";

results= bmql("modify MasterMetrics set $modifySet1, $modifySet2, $modifySet3, $modifySet4, modifySet5 where $modifySet1");

return "";

 

 

Error:

• Compilation error: Error in line 14, column 122: bmql: Encountered " "," ", "" at line 1, column 37.
• Was expecting one of:
• <EOF>
• "WHERE" ...

 

Any suggestion is appreciated.