Observe the current state in the Database Spy window
Use the Database Spy window to see the current state of the project while it is in break mode.
Your project must already be in break mode, either by reaching a break point that you set earlier or by using the Break tool to manually enter break mode, before you can use these tools.
The Database Spy window has four basic tabs (DB 1 through DB 4) that can be used at any time to view and adjust project tags and to excute in-line scripts. All four of those tabs work in the same way; four of them are provided simply to give you space to organize your work. For more information about using those tabs, see Database Spy.
- This tab shows all of the locally-declared VBScript variables and the current values of those variables.
Figure 2. Locals tab of the Database Spy window
- Stack Frame
- This tab shows additional information about the VBScript interfaces that are currently open for debugging. The interfaces are listed in order of mostly recently executed, so that you can see how one script calls functions in another, and the Line column shows the most recently executed line in each interface.
Therefore, in the screenshot below, you can see that execution was suspended at line 24 in the function Main_02 in the Global Procedures, and that the function Main_02 was previously called at line 97 of the Startup Script.Figure 3. Stack Frame tab of the Database Spy window
- This tab shows all of the run-time tasks that being debugged and the current state of each task.
Figure 4. Tasks tab of the Database Spy window
Note: At this time, only Background Task (Script) can be debugged, so it is the only task that will ever be shown in this tab. Other tasks may be shown in the future, as the debugging feature is enabled for more VBScript interfaces.
Keep in mind that these tabs show information only when a project is running in Debug mode and the project is in break.