re : data refresh at client side when a new data inserted in same table

By bijukmv ·

I read the article about data concurrency.

I want to now how can we refresh dataset with one client is on same form but on different record and another client enters a new record on same table, and this data should available to to first client without exiting the form with he has open.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Multiple access to data

by Toivo Talikka In reply to re : data refresh at clie ...

In database applications concurrent access can be controlled with table and row locking.

The concurrency scenario presents a challenge to the database designer where the designer must consider the transaction logic and the business rules, using the management of an online inventory database as an example. Certain types of updates to the product or category table may have to be limited to one online client at a time, in which case the table needs to be locked for the duration of the transaction. Certain maintenance operations like reorganization of the categories will have to be done offline.

Related Discussions

Related Forums