[SA 9.0.166 Pro] Syntax popup gets cut off with SPROC's

[SA 9.0.166 Pro] Syntax popup gets cut off with SPROC's

As you can see the popup help over the 'SELECT' is missing half of the bubble, also if you look down in the syntax checker the error at line 10, the message isn't entirely complete.. at the very least the missing end double quote is gone, if not the rest of the message.. which is probably inter connected with the bubble since they're probably showing the same message.

If I just change it to a simple error prone select statement and re-check the syntax the popup and error messages.

This same "problem" applies to functions, as I've just tested.

Can you please tell us if you are using ADO.NET or ODBC connection?

	SysOp wrote:
	Can you please tell us if you are using ADO.NET or ODBC connection?

ODBC, Driver={SQL Server}

ADO seems to solve the issue though. That's odd.

I was able to reproduce this issue with ODBC driver. It seems like ODBC driver returns two lines in the error message separated by NL character, while ADO.NET returns them separated by CR NL pair of characters. I will submit this one for further investigation because it's reproducible.

Thanks

I wonder why it only seems to occur inside functions or procedures while ad hoc statements give full error messages.

	Mindflux wrote:
	I wonder why it only seems to occur inside functions or procedures while ad hoc statements give full error messages.

Maybe, just maybe, add-hoc statements lead to single line in the actual error text, while errors inside procedures require a reference to procedure name in the first line followed by the syntax error in a separate line. Maybe ADO.NET reformats line breaks. I think we will know that soon.

Good point.

Our developers had a look at this issue, reproduced it too, and classified it as a bug related to conversion of error messages from Unicode. They promised a fix will be in the next publicly released build expected early next week if it's ready.