updation in more than one table

hi when data is enterd on a form and suppose that the data enterd is updated in 5 tables and if after updating two tables what if an error occurs? will the two tables be updated and the remaining tables will not be updated or the whole transaction is rolled back?

Hi Kumar, If you are updating 5 tables and an error occurs the Roll back depends on your the Commit Statment. Eg. You accept a value from user ‘GEN1’ and have a push button on the form for updating the Customer / Vendor / Employee table at the sametime and if an error occurs it will rollback and no changes will be made. Vishal NCSD

Kumar, commit-rollback will always rollback all changes since the last commit. This is a good thing! Avoid the use of the Commit statement if at all possible! Bill Benefiel Manager of Information Systems Overhead Door Company billb@ohdindy.com (317) 842-7444 ext 117