Hi I have the following problem. Im using autocommit off. I start by inserting into table1.
I then want to insert into table2 that has a foreign key to table 1. (I use generatedkeys from my insert) This fails since it cant obtaing a lock on table1 Is that expected? If I add a commit between the two statements it works. /Micke
