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

(0) Share

Report

Posted on by dark_knight

942

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.

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Leo Chen on at

Like (0)

Report

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.

Was this reply helpful? Yes No
dark_knight 942 on at

Like (0)

Report

Thank you. Will proceed with this))

Was this reply helpful? Yes No