views in edit modus refer to master db

Avatar
  • updated
  • Answered

I get the error = "Invalid object name 'master.dbo.OvernightStep_Sequence'" 

when I do an edit on one of the columns of the view.  (So no error executing the view)

 

The edit of that same column does work when I copy the view sql text and execute with the USE statement

 

use IMP_S1_000_BE_COMMN_EOD
SELECT TOP (100000) dbo.OvernightStep_Sequence.StepOrder, dbo.OvernightStep_Sequence.StepTarget, dbo.OvernightStep_Sequence.TargetID,
dbo.OvernightStep_Sequence.CallingScript, dbo.OvernightStep_Sequence.WeekSchedule, dbo.OvernightStep_Sequence.GroupName, dbo.OvernightStep.StepNumber,
dbo.OvernightStep.StepDescription, dbo.OvernightStep.StepTimeOut, dbo.OvernightStep_Library.StepType, dbo.OvernightStep_Library.StepSubType,
dbo.OvernightStep_Library.StepLibraryDescription, dbo.OvernightStep_Library.PossibleParameters, dbo.OvernightStep_Library.ExecutionDetails,
dbo.OvernightStep_Library.ModelGroupSupport, dbo.OvernightStep.TriggerType, dbo.OvernightStep.TriggerParameter
FROM dbo.OvernightStep_Sequence INNER JOIN
dbo.OvernightStep ON dbo.OvernightStep_Sequence.Objid_OvernightStep = dbo.OvernightStep.objid INNER JOIN
dbo.OvernightStep_Library ON dbo.OvernightStep.objid_OvernightStep_Library = dbo.OvernightStep_Library.objid
ORDER BY dbo.OvernightStep_Sequence.StepOrder

 

So can the developper not add the USE statement him/herselve  when running the edit component of the view.

BTW it will display the view correctly when F5 (execute), but error just happens when editing.

CTRL + F5 is no help here

Please solve.

 

 

 

Avatar

it is solved, it is a small issue when you make the connectionstring for the first time in an odd way.

(db identified + itselve also added).

no worries you will not encounter is and the tool works great now.

Avatar
Andrey Zavyalov, PM
  • Answered