The Debug DataBlade Module command

If you have a DataBlade® module project open in Visual C++ and click the Debug DataBlade Module button, the Debug DataBlade Module command performs the following steps:
  1. Checks if the DataBlade module needs to be compiled and compiles it, if necessary.
  2. If necessary, creates a directory for the DataBlade module under the %ONEDB_HOME%\extend directory.
  3. Installs the DataBlade module dynamic link library and SQL scripts in the %ONEDB_HOME%\extend\project.0 directory.
  4. If necessary, shuts down the database server.
  5. Starts Visual C++ debugger with the database server attached.
Important: The database server typically runs as a Windows™ service; you can start and stop it using the Services dialog box in the Control Panel. However, when the add-in starts the database server attached to the debugger, it does not run as a service and the Services dialog box does not show it running. You receive an error if you attempt to start or stop the database server by using the Services dialog box while it is attached to the debugger.
If the active window when you execute the Debug DataBlade Module command is an SQL file, the Debug DataBlade Module command launches IfxQuery, which performs the following additional tasks:
  1. If necessary, creates the database you specified in the Configure DBDK Visual C++ Add-In dialog box
  2. Connects to the database for the project
  3. Registers the DataBlade module
  4. If necessary, initializes the newly created database by using the Setup.sql file
  5. Executes the SQL statements from the active unit test SQL file until the first breakpoint is reached
  6. After you pass the breakpoint, executes the next SQL statement until the next breakpoint is reached
  7. After you pass all breakpoints and the routine returns, writes the results of the SQL statements to an HTML file
  8. Launches the default HTML browser for your computer
  9. Displays the SQL results in the HTML browser
  10. Shuts down

If the active window when you execute the Debug DataBlade Module command is not an SQL file, you can execute SQL queries by using another SQL query tool, such as SQL Editor. However, you must first explicitly register the DataBlade module by clicking the add-in Register DataBlade Module button or by using BladeManager (see the HCL OneDB™ DataBlade Module Installation and Registration Guide for instructions). In addition, the database you specified in the Configure DBDK Visual C++ Add-In dialog box must exist.