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.

Figure 1. Project in break mode, with yellow arrow showing where execution is suspended
Web Studio Help illus vbscript debugging 4 Observe the current state in the Database Spy window

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.

Tip: You may enter the names of VBScript functions (but not sub-routines) in the Database Spy window to get the returned values of those functions.
In addition to those four tabs, however, are three new tabs that only work with VBScript debugging:
Locals
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
Web Studio Help window databasespy locals Observe the current state in 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
Web Studio Help window databasespy stackframe Observe the current state in the Database Spy window

Tasks
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
Web Studio Help window databasespy tasks Observe the current state in 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.

Observe the current state in the Database Spy window