PRB: Second User Overwrites Changes Made by First User

ID: Q191047

The information in this article applies to:

Microsoft Visual InterDev, version 6.0

SYMPTOMS

After saving and reopening procedural objects, such as procedures, functions, and triggers, previous edits are lost. This can occur if a different user opened the object during your editing session.

CAUSE

This is by design. Visual InterDev 6.0 does not check for exogenous changes made to the object before you save it.

RESOLUTION

To work around this problem, do one of the following:

Click Save As to save the object source text before closing.

Use database projects and edit-compile with SQL scripts.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

In separate instances of Visual InterDev, insert identical data connections.

Instance1: Open a stored procedure.

Instance2: Open the same stored procedure in a second instance of Visual InterDev.

Instance2: Edit and Save the stored procedure in the second instance of Visual InterDev.

Instance1: Save the stored procedure in the first instance of Visual InterDev.

RESULT: No error or warning appears, and the second instance's edits are missing.

Additional query words:


Keywords          : kbCtrl kbide kbVisID600 kbGrpASP 
Version           : WINDOWS:6.0
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 25, 1999