How can we help you today? How can we help you today?

Selecting view on join didnt complete text

While editing a proc.

I had the following bit of code (in a more complex proc):

LEFT JOIN cus_Customer C ON C.CustomerID=M.CustomerID
LEFT JOIN sec_Person P ON N.ActionedByID=P.PersonID
INNER JOIN view_cus_Org

I pressed control-space and the view i wanted came up in the candidate list as the only entry. I pressed enter and the view didn't auto-complete. Tried this a few times and it didn't complete (in that instance).


Did some more testing:
	SELECT *
	FROM cus_OrgEntityNotification N
	INNER JOIN cus_OrgEntityNotificationAction NA on NA.OrgEntityNotificationID = N.OrgEntityNotificationID
	INNER JOIN view_cus_OrgEntityGroup OEG on OEG.OrgEntityID = NA.OrgEntityID
	INNER JOIN view_cus_Or

	SELECT *
	FROM cus_OrgEntityNotification N
	INNER JOIN view_cus_Or

Having a script with only the above code on it, it completed fine for the 2nd half, the first half wouldnt complete.
lysp
0

Comments

4 comments

Sort by
  • Bart Read
    Sorry, just to be absolutely clear: you hit ENTER (or whatever) and it didn't insert anything at all? Sounds a bit nasty. Could you tell me which editor you were using please?
    Thanks,
    Bart
    Bart Read
    0
  • lysp
    I was using SSMS.

    What happened is after i pressed enter the candidate box just disappeared. I could press control-space and get it to show up again and then enter would just leave it incomplete.

    I'll have a play around and see if i can replicate it.
    lysp
    0
  • lysp
    Ok, i think i have been able to reproduce this using AW.
    SELECT *
FROM HumanResources.Department A
INNER JOIN HumanResources.vEmployee V on vEm

    The list shows 3 items, the 2nd one clicks ok, the first doesnt click.

    Can someone please confirm this?
    lysp
    0
  • Bart Read
    OK thanks, we'll look into it.
    Cheers,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.