Field LineNbr

(0) Share

Report

Posted on by Ulyses Rico

630

Hello, I'm using a process of insert and I need to create a LineNbr, I know it has to negative but does it have to be consecutive? Is that a condition to the process or it's ok if I just insert a negative number?

*This post is locked for comments

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Field LineNbr

You did not indicate what table you are inserting a record into but it depends on whether the LineNbr field is part of a unique index into that table. If you open SQL Management studio and execute the following command

sp_help xxxxxx where xxxxxx is the table involved

you can scroll down to the index definitions for that table and see if LineNbr is part of a unique index. If the table is one of the standard SL tables then it is very likely that LineNbr must be unique or, at least, unique within the other elements of the index.