Options

Specify a table to recreate in AL

wolfskinwolfskin Member Posts: 84
Hi everyone,

I got a problem while creating an extension on NAV 2018 on-premise.

When I change field 's DataType from Integer to be Decimal, I got an error message like this

'SchemaUpdateMode=synchronize failed with code 422. Reason:
Table 50010 :: Unsupported field change. Field:Sequence No.; Change:DataType'

I know this error can be fixed by changing "schemaUpdateMode" to "Recreate" but all data records in this project will be deleted which I don't want to be like that.

Is there anyway to specify only a table to recreate or compile only a table like C/SIDE?


Thanks you,

Best Answer

  • Options
    DuikmeesterDuikmeester Member Posts: 304
    edited 2019-05-10 Answer ✓
    Welcome to AL. Create a new field and mark the "old" obsolete.

Answers

  • Options
    DuikmeesterDuikmeester Member Posts: 304
    edited 2019-05-10 Answer ✓
    Welcome to AL. Create a new field and mark the "old" obsolete.
Sign In or Register to comment.