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

(0) Share

Report

Posted on by dark_knight

795

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 (3)

Answers (2)

dark_knight 795 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,091 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.