As AX doesn't support back slash value "\" value in X++ code but allows the same value in data base field value (In Table Field value) , So some time it's hard to get the expected value in query . I had the same problem which i got by below solution.
Problem : -
LedgerJournalTrans hold a value with back slash (MP\PV16\000014). When i was getting the value in query to pass it in a range it was removing "\" Automatically which was the case of data mismatch and value was not coming from table. Our report was showing blank data in report.
Solution:-
Query doesn't recognize single back slash. so we use to use double back slash "\\" to define a single slash in a value. If we are getting a from any table then we have to convert single slash in to double slash. For that we have to type four slash "\\\\".
voucher = strReplace(contract.parmVoucher(),"\\","\\\\");
here our value (MP\PV16\000014)contain single slash which we are replacing with double slash by four time slash.
Problem : -
LedgerJournalTrans hold a value with back slash (MP\PV16\000014). When i was getting the value in query to pass it in a range it was removing "\" Automatically which was the case of data mismatch and value was not coming from table. Our report was showing blank data in report.
Solution:-
Query doesn't recognize single back slash. so we use to use double back slash "\\" to define a single slash in a value. If we are getting a from any table then we have to convert single slash in to double slash. For that we have to type four slash "\\\\".
voucher = strReplace(contract.parmVoucher(),"\\","\\\\");
here our value (MP\PV16\000014)contain single slash which we are replacing with double slash by four time slash.
No comments:
Post a Comment