editing a stored procedure

[Bernard Devlin]

OK I worked this out.  The issue is that VStudio does not display the
text of the changed procedure until the 'refresh' button is clicked.

There may well be good reasons for that, and I can live with it.
Although it is such strange behaviour it needs to be signposted.  In
Lotus Notes where data in a view might get changed in the background
by someone else, the view of the data is marked as stale by the means
of a 'refresh view' icon that appears in this situation.  Thus,
instead of automatically updating the view, the user is left to choose
when that update process happens BUT is also made aware that what they
are viewing is a stale representation of the data in the database.
There are arguments why such stale views should be preserved in e.g.
the Data Browser of VStudio, but to display the stale state in the
Schema Editor seems like a defect to me.

Furthermore, I do think that it is a bug that when one chooses to
'edit' from the context menu of a SP that one is taken to edit the old
text if the 'refresh' button has not been clicked.  Opening up a SQL
Editor on the text of a SP should display the current text of the SP
not the old text.

Bernard

On Sat, Jan 23, 2010 at 10:39 AM, Bernard Devlin <bdrunrev at gmail.com> wrote:

> HOWEVER, in scenario 1) where everything has apparently worked, when I
> close the SQL Editor and return to the Schema Editor, and look at the
> code for the SP displayed there, it shows the changes have NOT taken
> place.  This is not just an issue with the Schema Editor displaying
> the old code; if I choose 'edit' from the SP in the Schema Editor,
> when the SQL Editor opens it is showing the old SP code.