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)

Suggested answer

Mohana Yadav 61,001 Super User 2025 Season 2 on at

Like (0)

Report

Please use Evaluate function

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

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

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

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,397 on at

Like (0)

Report

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,380 Super User 2025 Season 2 on at

Like (0)

Report

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,284 Super User 2025 Season 2 on at

Like (0)

Report

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