Contents Index Disabling and enabling breakpoints Working with variables

ASA SQL User's Guide
  Debugging Logic in the Database
    Working with breakpoints

Editing breakpoint conditions


You can add conditions to breakpoints, to instruct the debugger to interrupt execution at that breakpoint only when a certain condition or count is satisfied.

To add a condition or count to a breakpoint

Examples 

In the procedure sp_contacts, you might use the breakpoint

contact.id = contact.old_id

on the line

DELETE FROM contact WHERE contact.id = contact.old_id

In the Java method JDBCExamples.Query(), you might use the breakpoint condition

(price < 10)

on the line

if (max.price == price) or (price == 10)

Contents Index Disabling and enabling breakpoints Working with variables