For detailed instructions on how to use the debugger you can view the "SQL Anywhere Debugger" section in the help file. The steps summarize as follows:
- Locate your procedure or function in the Object Browser.
- Right click on the procedure or function and select the Debug option.
- A parameter window will display allowing you to enter the values that will be passed to the procedure or function. Once the parameters are entered, click the debug button to go to the debug window (first toolbar button).
- A debug window will open with two tabs.
- The first tab will contain the SQL that will be used to execute the procedure or function. You can adjust this SQL if needed.
- The second tab will contain the DDL for your procedure or function. You can set breakpoints in this tab. If the procedure or function calls out to another procedure or function you can right click on the name in the editor and select the Go To Definition option to view it's code. Breakpoints can be set in the new tabs that open as well.
- Breakpoints can be set by clicking in the margin (the space to the right of the line numbers) or by clicking the Toggle Breakpoint toolbar button.
- Once your breakpoints have been set, click the debug button to start the process (the first toolbar button).
- Use the debug toolbar buttons to control the debugger (e.g. step over, step in etc.)
- You can set more breakpoints while debugging.
- The debug process can be stopped anytime by clicking the Stop Debug toolbar button.
Please let us know if you find any bugs or if you feel there's a better way to handle the debug process. You can email support@werysoft.com with any questions or comments.
Thanks,
The Werysoft Team
No comments:
Post a Comment