use of commit and rollback

Original Message

Name: trichyselva
Date: April 18, 2006 at 23:08:48 Pacific
Subject: use of commit and rollback
OS: windows xp
CPU/Ram: p4
Model/Manufacturer: pentium

Comment:

suppose i execute 10 sql's, i want to commit 6 sql's and rollback 4 sql's, is there any way to do it ( i haven't mentioned savepoint anywhere between the sql's), any other way other than savepoint

Report Offensive Message For Removal

Response Number 1

Name: lchi2000g
Date: April 19, 2006 at 17:51:00 Pacific

Reply: (edit)

YES.
rollback and run the 6 sql's again and commit it.
I was just joking. The real answer is NO.

Luke Chi

Report Offensive Follow Up For Removal


Script to check database status Remote copies of Act 6 running slo mysqld-nt.exe consumes most of CPU Designing Check Printing System Act! 6.0.3	Fractions in MySQL help with ACT! 2006 Brilliant Database Professional Scroll Bars on Access Form MS Access Simple Database

inserting rows into table

Designing Check Printing ...

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: use of commit and rollback

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL: