web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to convert Str to int

Finance | Project Operations, Human Resources, ...

Unanswered

How to convert Str to int

(0) Share

Report

Report

Posted on by Tayyab Hussain

28

I have the following code

while
select sum(any2Int(SLD_Bundles))
from _ProdTable
group by _SiseChart.SizeID
join SizeId,DropId
from _SizeChart
where _SizeChart.InventSizeId==_InventDim.InventSizeId
{
//Bundle = str2Int(_ProdTable.SLD_Bundles);
CBLTblSchdDataBundleTmp.SLD_BUNDLE=_ProdTable.SLD_Bundle;
CBLTblSchdDataBundleTmp.SIZEID=_SizeChart.SizeId;
CBLTblSchdDataBundleTmp.DROPID=_SizeChart.DropId;
CBLTblSchdDataBundleTmp.insert();

How do I convert string to Int. The field SLD_Bundle is an nvarchar in the table

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Martin Dráb 238,789 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If you have such a need, it sounds like a bug in the data model and the right solution is change the data model.

As far as I know, there is nothing in X++ select statements that would instruct SQL to do such a conversion. But you could create a view with such a computed column and sum this view instead of the table.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 521 Super User 2026 Season 1

#2

Giorgio Bonacorsi 438

#3

Adis 261 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans