Update the Inserted record while Autocommit is false

[Azrael Noor]

First
Autocommit is FLASE

then Insert a record

then update same record in same session and same user id

commit it

Insertion is done succesfully but Updation on same record is not done

Same query is working when i later done updation

Why so?

[Wendy Gibbons]

it sounds like a bug in your code, can you produce a small working sample that displays this.
all it would do is exactly as you have described in your description. The bit about it working later does not need to be shown, as we don't need to see the working code.

[Azrael Noor]

Sir i have marked the status as solved
the database was new to me and their was some trigger which was not letting me doing this and i was not aware of this.

Thank you

[Wendy Gibbons]

thank you for letting us know.