I have just deployed an small application on three PC which are all PIII 500 32MB. The apllication started to hand the PC after entering 15 to 20 records. I had not used transaction while saving to file. After introducing begin & end transaction in save and delete routine the problem was sorted out.

Now the only place where the PC hangs is when the user wants to reverts after stating a add or edit procedure. Here as tablerevert function cannot be included in begin & end transaction I am clueless about which way to go to solve this problem.

Is begin & end transaction necessary while updating more than one table.


Rajesh