Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Automating Tasks Using Schedules and Events » Event handling tasks

Triggering an event handler Next Page

Debugging an event handler

Debugging is a regular part of any software development. Event handlers can be debugged during the development process.

To debug an event handler

  1. Start Sybase Central.

    From the Start menu, choose Programs > SQL Anywhere 10 > Sybase Central.

  2. Connect to your database.

  3. Change to Debug mode by choosing Mode > Debug.

    The Debugger Details pane appears at the bottom of the Sybase Central main window.

  4. In the Folders pane, open the Events folder.

  5. Double-click the event you want to debug.

  6. On the SQL tab in the right pane, click the left margin beside the line where you want to add a breakpoint. A red stop signs appears, to indicate that a breakpoint has been set. Alternatively, you can press F9 to set a breakpoint.

  7. From Interactive SQL or another application, trigger the event handler using the TRIGGER EVENT statement.

  8. The execution stops at the breakpoint you have set. You can now use the debugger features to trace execution, local variables, and so on.

See also