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
Printable View
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
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.
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.