3 replies to this topic

[msrajamca]

Hai,

I am new in vb6. Now i was started a programe for developing Granite Processing System. For that i have lot of problems.

For ex:

If i click the save button, it will execute all queries i am writing. it is having 5 insert statement. after completing 3 queries i have an error for some thing. Execute all five queries without an error this is exexute. Inbetween any errror will occur i will be remove the last transaction.


How to Use the transactions.

[Xav]

What's the error message?

[mbshinde78]

I think you can use begintrans and committrans. This will allow you to either insert all transactions or insert none.

[Colanth]

set a boolean (say bError) to False
begin the transaction
do your inserts here
after each insert, if there's any error set bError to True)
after all the inserts, if bError is false
commit the transaction
else
roll back the transaction (and give the user some indication of what happened)