Identity cannot be determined for newly inserted rows
Mark,
Thanks for the reply. I am using begintrans and committrans on my
connection. The error occurs when I try to modify a record after the rs has
been updated and before commitrans is called to end the transaction.
Thanks,
Erica
Quote:
> You can manage the multiple table update with begintrans committrans on
your
> connection object. All the calls between begintrans and committrans are
> commited together.
> > Hi everyone!
> > I have a project written in VB6 with SQL 7. I have a portion that
consists
> > of 4 forms and accesses 6 recordsets. After updating the fields of each
> > recordset I do an updatebatch. If I then go back and try to change a
field
> > in one of the records, I get the error message "Identity cannot be
> > determined for newly inserted rows". If I don't do the updatebatch then
> when
> > I try to add records to the other recordsets I am violating my key
> > contraints. Can anyone give me some advice? I don't want to commit the
> > transaction until they are completely done with all the modifications.
> > Thanks so much!
> > Erica
