News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... changing the type of t...

Finance | Project Operations, Human Resources, ...

Answered

changing the type of the field in the table from int to int64

(0) Share

Report

Report

Posted on by dark_knight

768

Hello,

I have a table with the field that stores int values. Now I need to insert int64 values to that field. Table field is based on EDT which is inherited from int. How to change the table field in order to save int values that I already have? If I create new int64 EDT and will point out this new EDT in the properties of my table field will it work then? Won't I lose my int values already stored in this field?

Thanks.

All responses Img

All responses (3)

Answers Img

Answers (2)

dark_knight 768 on at

Like (0)

Report

RE: changing the type of the field in the table from int to int64

Thank you. Will proceed with this))
Verified answer

Leo Chen on at

Like (0)

Report

RE: changing the type of the field in the table from int to int64

You are not allowed to change a field's EDT from int to int64 types, as they are different types. It's just like you cannot change a field type from string to Real.
Verified answer

Sergei Minozhenko 23,089 on at

Like (0)

Report

RE: changing the type of the field in the table from int to int64

Hi Azat,

You can create new int64 field, copy data from the old field to the new field via job or SQL script, and use the new field in code instead of the old one.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans