![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461961865.webp)
Connector/Net Visual Studio Integration
1845
Figure 20.26. Function Stepping (2 of 2)
• To step into the code of a condition handler, the condition must be triggered in the rest of the MySQL
routine.
• The next statement to be executed is highlighted in yellow.
• To continue stepping, you can choose between Step Into (by pressing F11), Step Out (by pressing
F10) or Step Over (by pressing Shift+F11).
• You can step out of any of functions, triggers or stored procedures. If you step from the main routine,
it will run that routine to completion and finish the debug session.
• You can step over stored procedure calls, stored functions, and triggers. (To step over a trigger, step
over the statement that would cause the trigger to fire.)
• When stepping into a single statement, the debugger will step into each individual function invoked
by that statement and each trigger fired by that statement. The order in which they are debugged is
the same order in which the MySQL server executes them.
• You can step into triggers triggered from
INSERT
,
DELETE
,
UPDATE
, and
REPLACE
statements.
• Also, the number of times you enter into a stored function or trigger depends on how many rows are
evaluated by the function or affected by the trigger. For example, if you press F11 (Step Into) into
an
UPDATE
statement that modifies three rows (calling a function for a column in the
SET
clause,
thus invoking the function for each of the three rows), you will step into into that function three times
in succession, once for each of the rows. You can accelerate this debug session by disabling any
breakpoints defined in the given stored function and pressing Shift+F11 to step out. In this example,
the order in which the different instances of the stored function are debugged is server-specific: the
same order used by the current MySQL server instance to evaluate the three function invocations.
Breakpoints
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...