about _RefPackitem table

[ahmed4ever2u]

well i'm writing my own query which it will help me to add custom items to the npc with the codename only !
so all works as far as i can feel it now
but i have a wired error shows if i tried to add another item ( the error cased by the Identity in _RefPackageitem)

my codes

if not exists ( select ID from _RefPackageItem where ID = 1 )
	SET @ID = '1'
if exists ( select ID from _RefPackageItem where ID = 1 )
	SET @ID = (SELECT TOP 1 ID FROM _RefObjCommon ORDER BY ID DESC )+1

it works fine for the first item !
but if i tried to add 2nd item it works fine but with a hecka high ID ! =
but if i tried to add the 3rd item i get this error !

so i wonder which part made this error ?

----------------------Edit
already solved

if not exists ( select ID from _RefPackageItem where ID = 1 )
	SET @ID = '1'
if exists ( select ID from _RefPackageItem where ID = 1 )
	SET @ID = (SELECT TOP 1 ID FROM [B][COLOR="DarkRed"][COLOR="Red"]_RefObjCommon[/COLOR][/COLOR][/B] ORDER BY ID DESC )+1

it should be _RefPackageitem Not _RefObjCommon my bad sorry

[intercsaki]

Solved?

#Request close, then.