Item_number update query problem

rated by 0 users
This post has 1 Reply | 1 Follower

Top 50 Contributor
Posts 29
Points 235
zapping Posted: Thu, May 27 2010 4:28 AM

Hi all,
  The update on part table for the field item_number creates some problem for our business rules. Any help on it is highly appreciated. Whenever the item_number field is updated a new record gets inserted with a new ID. Can you let me know why this happens. Also is there a way to avoid this. As we require the ID field not to change for the updated Item_number record.

cheers.

Top 50 Contributor
Posts 29
Points 235
zapping replied on Thu, May 27 2010 4:54 AM

Hi,
 Could make out that the part was set as versionable and so the new insertion. Is there any down fall in setting part as non-versionable?

thx

  • | Post Points: 5
Page 1 of 1 (2 items) | RSS