Software·43,881 discussions

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

Locked

Sir,

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.

thanx
bye
biju

Topic

Clarifications

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

Clarifications

Multiple access to data

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

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.

[Author]

Replies