Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

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

Posted on by 763

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.

  • dark_knight Profile Picture
    dark_knight 763 on at
    RE: changing the type of the field in the table from int to int64

    Thank you. Will proceed with this))

  • Verified answer
    Leo Chen Profile Picture
    Leo Chen on at
    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 Profile Picture
    Sergei Minozhenko 23,083 on at
    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

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans