Small and medium business | Business Central, N...

How to convert data type Code to Integer?

(0) Share

Report

Posted on by Prathama

Hi Guys,

I am trying to do setrange, but my 'Primary Key Field 2 No.' is Integer data type and Data type of 'No.' is Code.

How to convert code to integer data type?

Please let me know is there is any way to do this.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Mohana Yadav 61,214 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Please use Evaluate function

learn.microsoft.com/.../evaluate-function

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

You idea is wrong to filter the data, you need to change your logic, or brief your requirement here.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi, Prathama Deshpande.

you can also use the SetFilter,

ChangeLogentry.SetFilter("Primary Key Field 2 No.", '=%1', Rec."No.");

Regards

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,421 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

excuse me

don't understand?

what table is your Rec referring to?

in the 'Primary Key Field 2 No.' field of the change log is the field ID entered? what does your Rec.No refer to?

maybe the logic you are using is not quite right?

Anyway, to convert a code to an integer use the function

EVALUATE(varInteger,VarCode) function;

but in your case you can do a setfilte(yourfilterfield,'%1',rec.no);

DAniele

Was this reply helpful? Yes No
Suggested answer

Saurav.Dhyani 14,419 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

You are doing incorrect setrange - The Field Primary Key Field 2 No. stores the field no. of the table whose record is stored. You should be doing two setrange-

1. Primary Key Field 2 No. --> Field No. in Table.

2. Primary Key Field 2 Value --> Value that you want to filter (Rec."No.").

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,306 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I think you are using the wrong field for filtering. Try using "Primary Key Field 2 Value".

ChangeLogEntry.SetRange("Primary Key Field 2 Value", Rec."No.");

Was this reply helpful? Yes No