Buffering in VB

[Arunesh]

Hi
In VB there is any concept like buffering before i put them in the database ?
Also I tried to Use BeginTrans and CommitTrans using ADOData Control ,but the moment i did recordset.update ,the rollbackTrans didnt work . The Transaction was valid but the roll back at the database did not work.
Could some one tell me how do i implement the above , in any other way ??..

Quick help would be really appreciated.

Thanks a lot,
Arunesh.

[Lothar Haensler]

instead of using the ADO data control you can write ADO code as in

conn.BeginTrans
conn.Execute ....
conn.CommitTrans or conn.rollback...



That does work.