Confirmation

[nbanaji]

When inserting records in a remote database(over the Internet), how can I make sure that all the records have been inserted? The entire operation should happen as a transaction. Pl. advice. Thanks

[lenin]

What database are you using. If SQL server retrieve @@error for last action i.e. updates or inserts, or perhaps use the MTS objectContext() mechanism to control transactions.

Lenin.

[honeybee]

If you intend to work with SQL Server or Oracle, both these support the use of transactions. You can issue a Begin Transaction command in the beginning, before any data updations start. Once all updations and insertions are over, issue a Commit Transaction command which will ensure that all the changes are physically written to the database.