PRB: Breakpoints Not Hit in Multiple Line SQL Statements (169403)

The information in this article applies to:

Microsoft Visual C++, 32-bit Enterprise Edition 4.2
Microsoft Visual C++, 32-bit Enterprise Edition 5.0
Microsoft Visual C++, 32-bit Enterprise Edition 6.0
Microsoft Visual Basic Enterprise Edition for Windows 5.0

This article was previously published under Q169403

SUMMARY

MORE INFORMATION

In the case of the UPDATE statement listed above, the debugger will allow breakpoints to be placed on the SET clause to the UPDATE statement because SET is a valid SQL command. Unfortunately, the breakpoint will not be hit because SET is part of the multiple line UPDATE statement and therefore not considered a separate SQL statement.

SYMPTOMS

When trying to debug stored procedures, it is possible to run into the following behavior. Examples are listed below:

   UPDATE <table1>
      SET <column>=0 WHERE -- SET clause of UPDATE statement is an invalid
      breakpoint

   SELECT * FROM <table1> where NOT EXIST
      (SELECT * FROM <table2> WHERE... ) -- subselect statement is an
      invalid breakpoint

CAUSE

The problem is that the debugger will allow invalid breakpoints set on certain SQL statements. The problem with this behavior is that the break point is never hit.

RESOLUTION

The listed behavior is inherent in the lexer because it is based on what is in the first line and does not handle multiple line SQL statements.

STATUS

Microsoft has confirmed this behavior to be by design in the Microsoft products listed at the beginning of this article.

Modification Type:	Major	Last Reviewed:	12/10/2003
Keywords:	kbprb KB169403