Make change on Records

Hi,
I have an application, in which there's a button called "What If".
When the user pressed this button, every changes they made on the records
displayed in form wouldn't affect the real records until the user press
another button called "Accept changes".
Is there any way i can do it via MS Sql Database?
Pls. advice and thanks in advance
pcPirateHi Pirate ( Do you really ?)
What will be happend if the user pressed a button "What if" and went to
take a coffe ( for two hours...)?
Do you really block others until he/she presses another button?
Consider using SELECT with (UPDLOCK) please refer to BOL.
UPDLOCK has the advantage of allowing you to read data (without blocking
other readers) and update it later with the assurance that the data has not
changed since you last read it
"pcPirate" <pcPirate2003@.hotmail.com> wrote in message
news:OeNRYoa#DHA.3436@.tk2msftngp13.phx.gbl...
> Hi,
> I have an application, in which there's a button called "What If".
> When the user pressed this button, every changes they made on the records
> displayed in form wouldn't affect the real records until the user press
> another button called "Accept changes".
> Is there any way i can do it via MS Sql Database?
> Pls. advice and thanks in advance
> pcPirate
>