AutoIncrement Property of the filed

Isaland · 2012-09-21

Hello

There is a new table with primery key "Entry No." (Integer)
Сustomer need AutoIncrement Property for this field.

I have simple report, which imports lines from Excel to this table.
When it try to Insert second line, it use previous "Entry No." and runtime error occurs

How to perform Navision increment "Entry No." after Insert?

kine · 2012-09-21

It depends on your code. When inserting data into Autoincrement table (table with field with enabled Autoincrement), you need to set the field to 0 and do the insert. You cannot set it before insert, else it will give you SET IDENTITY error when you are not db_owner.

lvanvugt · 2012-09-21

Did you set the AutoIncrement property on the "Entry No." field?

kine · 2012-09-21

It depends on your code. When inserting data into Autoincrement table (table with field with enabled Autoincrement), you need to set the field to 0 and do the insert. You cannot set it before insert, else it will give you SET IDENTITY error when you are not db_owner.

Isaland · 2012-09-21

kine wrote:

It depends on your code. When inserting data into Autoincrement table (table with field with enabled Autoincrement), you need to set the field to 0 and do the insert. You cannot set it before insert, else it will give you SET IDENTITY error when you are not db_owner.

Thanks, it works. I put "Entry No." := 0; before Insert :thumbsup:

AutoIncrement Property of the filed

Best Answer

Answers

Categories