Autosplitkey Property can't find Key

Comments

• tvandongen Member Posts: 78

  2004-08-10

  Navision calculate the line number by dividing the line number of the previous line and the current line. For example:
  First line number is 10000
  If you want to insert a line before, the second line number will be (10000+0)/2=5000.
  Will you do this another time then the third line number will be 2500
  
  etcetra. On a certain moment there is no possibleity to create a new number and your error is occuring.
  
  Solution. Go down one line and insert the other lines there.

  0
• DenSter Member Posts: 8,307

  2004-08-10

  You can insert 13 lines between 2 other line numbers. Navision will fail on the 14th I believe.
  
  5000
  2500
  1250
  625
  313
  165
  78
  39
  20
  10
  5
  3
  2
  1
  
  Well maybe the 15th . whatever... Just create a sales order and insert a line between two existing ones, repeat and see how many lines you can insert. If your customer needs to insert an unlimited number of records, you will need to write some code to renumber the lines when a new line is inserted.

  Daniel Rimmelzwaan
  RIS Plus, LLC

  0
• tvandongen Member Posts: 78

  2004-08-10

  Of course you could also create an separate (reverse) index for your form

  0
• elTorito Member Posts: 191

  2004-08-11

  tvandongen wrote:

  Of course you could also create an separate (reverse) index for your form

  
  Hello and thanks for you answers. Now I see how it works,
  this occurs momemntanly at two Records, i was gone and change in the Comment Line Table der Line Numbers Manually, so that can be put other Rows above the existing.
  
  If this occurs a lot of time then i think try create an reverse index.
  
  regards
  
  Piter

  (Oo)=*=(oO)

  0