Efml Update from database, column NEXT VALUE
Posted: Mon 02 May 2022 13:24
Version: 6.12.1419
I detected a problem, to occur was like this:
I have a table with a column that has a string. Not the Identity column.
The default field contains the value: NEXT VALUE FOR [dbo].[sqTable]
When updating the model, it correctly identifies and puts the Generated Value as OnAdd and my Model setting sets it to private.
All right. The problem is that it always updates this field when I try to update the model from the database.
In the description of the database update, the field always appears: Identity(old='True', new='False') was changed.
This makes it difficult to really know what was modified in the database, having to go table by table in the listing to verify.
I detected a problem, to occur was like this:
I have a table with a column that has a string. Not the Identity column.
The default field contains the value: NEXT VALUE FOR [dbo].[sqTable]
When updating the model, it correctly identifies and puts the Generated Value as OnAdd and my Model setting sets it to private.
All right. The problem is that it always updates this field when I try to update the model from the database.
In the description of the database update, the field always appears: Identity(old='True', new='False') was changed.
This makes it difficult to really know what was modified in the database, having to go table by table in the listing to verify.