>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.
Preferable.
Use ROLLBACK.
>
>
>Rajesh
Insanity: Doing the same thing over and over and expecting different results.