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.
Tagged:
0