thank you. i will try that method, but before I get your suggestion, I tried to add another sql command just execute the commit after the insert one, I still face the bug as it was.