Use the same sql Server table to do different updates, is there a way to
do that?
Im using Asp.net (VB.net), in my Database :
have One table called (Trade), the same rows of this table are used from 3
different users, These users can make different updates on this table,
they should see the basic informations of the table (I mean by the Basic,
before the table (trade) has been updated)
The problem is here when the fist user wants to modify the table's rows,
the second and third user can not see the basic informations any more, and
if they decide to change or update some data, the fist will lose his
updated rows..
The data will be overwritten every time the users make updates on the table.
What I want, is to know if there is a way to do like a copy, or an image
of the table for the 3 users, and every user can update normally, without
creating the same Table with the same rows 3 times??!
Thank you..
No comments:
Post a Comment