Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

How to convert Str to int

(0) ShareShare
ReportReport
Posted on by 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

  • Martin Dráb Profile Picture
    Martin Dráb 230,934 Most Valuable Professional on at
    RE: How to convert Str to int

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,111 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,934 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans