Share
ReportI need string functions which can used in X++. Specially I need sub string function, how we can get sub string using SQL query.
*This post is locked for comments
You’re offline. This is a read only version of the page.
2,055
I need string functions which can used in X++. Specially I need sub string function, how we can get sub string using SQL query.
*This post is locked for comments
X++ queries don't support such a kind of things. Consult the documentation (Select Statement Syntax [AX 2012]) if you don't know what's supported.
To achieve what you need, create a view with a computed column, handle the logic in the application layer or, as the last resort, run a direct SQL query.
Sorry actually I need sql sub string function to use in X++. I have try the following code but its not working.
select subStr(ChequeNum,1,3) from bankChequeTable
group by bankChequeTable.ChequeNum;
info(bankChequeTable.ChequeNum);
X++ function for substrings is called simply subStr().
Nevertheless database servers don't understand X++, so you can't use X++ function in SQL commands.
#1
Kempeth
4
#1
Andy Adamak
4
#1
Community Member
4
All responses (
Answers (
