Board index » delphi » begintrans, commit, rollback

begintrans, commit, rollback

Another question

I alwais have done this with BDE:

    Table.Append
    ...
    Table.Post;

but in ADO  I use transactions, so I think it is more robust:

    try
        Conection.BeginTrans
        Table.Append
        ...
        Table.Post;
        Conection.Commit
    except
        Conection.Rollback
    end;

But I have not find any BDE component that can use transactions or somethink
like it.
Have BDE any similar components to ADO transactions ??
Or if not, how is the securest way to write a record in a database?

Thanks

--
Esteban Olm
S.I.T.E.M., S.L.
Consultoria Tcnica en Sistemas de Informacin Geogrfica y Teledeteccin
Barcelona, Espa?a
http://www.sitem-consulting.com

 

Re:begintrans, commit, rollback


  The TDatabase component has trnasaction functions like this
(StartTransaction, Rollback and Commit, I think).
-Howard

Other Threads