PROBLEM with insert in table with indentity column??

• oce

  Newbie

  Points: 1

  More actions

  July 29, 2005 at 3:02 am

  #94117

  Hello ive got a problem

  I have a table in which i insert Clients by a request.

  My table have an indentity column witch is returned by my procstock when i do the inSert. This is the ClientIdentifier.

  Somethimes, the Insert failed :

  the procstock return the newClientIdentifier and says all is ok but in the table, the line doesn't exist and the index is incremented.....I don't understand why somethimes it failed and somethimes not with exactly the same request.And worst : why, when the insert failed, the prostock return a correct identifier??

  DO you have any idee?

   

  I use SQL SERVER 2000, my request use IDENTITY_CURRENT to return the nex idex.

   

  SORRY FOR MY BAD ENGLISH

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  July 29, 2005 at 6:50 am

  #578157

  So the row is not inserted at all - or the clientID is populated with the right value but all the other fields are null ?!

  Is there a delete being performed on the same table through some other event in the application ?

  What are the other database objects that this table is dependent on ?! Any triggers that involve this table ?

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**