View Single Post
  #3 (permalink)  
Old January 25th, 2009, 01:19 AM
Old Pedant Old Pedant is offline
Friend of Wrox
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

p.s.: I *suspect* that the reason it worked with the first album and first pictures is that when you created that new album it retrieved the IDENTITY value for the new albumID and *that* worked. But then when you go back and try to add to an existing album, it's not picking up the correct albumID. Pure guesswork, again.

p.p.s.: There *are* other possible reasons in SQL Server for this same error message, but they are at least an order of magnitude less likely than the one I've suggested.