Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

Field LineNbr

Posted on by 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?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans