Is there a line feed bug in QA? -- sql server programming

John MacIntyre
9/27/2005 11:21:56 PM

Hi,

I am having a heck of a problem on 2 machines (2k & XPPro). SQLServer
2000SP4

Query Analyzer keeps giving me problems and I lose hours tracking down the
problem.

Now I don't know exactly what QA is doing, but I do know that QA will show a
line break, but the proc is behaving as if the line break is not there.

For example, this will not work process the line following the comment;
-- comment
Exec sp_dosomething

But this will
/* comment */
Exec sp_dosomething

Does anybody know of a solution for this?

Thanks,
John

Tibor Karaszi
9/28/2005 12:00:00 AM

You might want to try find one CHAR(13) or only CHAR(10). A proper line break is CHAR(13) +
CHAR(10), aka CRLF. I recall some natyiness if you only had one of those and not the other, where QA
would display as line break but it didn't behave like a linebreak.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server programming

sql server programming : Is there a line feed bug in QA?