Does anyone know why tessitura is trying to insert a number into my table that is set as an id_key IDENTITY (1,1)? This should start at 1 and increment by 1. I am getting an IDENTITY_INSERT error because of this and it therefore is not allowing me to add via my custom tab. Just an FYI, I ran a trace and the number that tessitura is trying to insert is consistently a number in the 9,000 range.
Any thoughts would be helpful and thank you in advance!
Joe
Hi Matt
This might seem really basic, but is it possible that in the stored procedure or the select that’s behind the custom screens, there’s a where clause that is a fixed customer_no rather than a variable? I know I will often put in a specific customer_no when I am testing and it is easy to forget to comment it out and uncomment the variable.
Just looking for the mole hill before the mountain ;-)
Regards
Sandra