• run the test of a stored procedure: by itself from the editor (see Stored procedure).
• connect the debugger onto an existing connection to trace a problem in real time.

Running the test of a HFSQL Client/Server connection

1. Open the requested project in the editor.
2. Display the analysis linked to the project: click among the quick access buttons.
3. Under the "Project" pane, in the "Test mode" group, scroll down "Test mode" and select "Debug on a HFSQL server".
4. In the screen that is displayed, select:
   • the user identified on the server for debugging.
   • the mode for running the test and the debugger.

• Starting the project and debugging the next connections to the database.
• Debugging the next connections to the database coming from a specific user for a specific application.
• Debugging an existing connection.

Mode 1: Starting the project and debugging the next connections to the database

• start the current project (without the debugger),
• debug the stored procedures and the triggers used from the project on a database. The elements deployed on the server are run.

• The port used for debugging is port 27281 by default. This port must be opened if a firewall is used. Indeed, the communication between the development computer and the end-user computer is done via socket. This port can be modified in the HFConf.INI file.
• The user who is using the database must have the rights to debug on the database.

• The Ctrl + Pause combination cannot be used to start the debugger. You have the ability to use breakpoints.
• The F7 keys cannot be used on HExecuteProcedure or HExecuteQuery.
• InTestMode returns False.

Mode 2: Debugging the next connections to the database coming from a specific user for a specific application

• The port used for debugging is port 27281 by default. This port must be opened if a firewall is used. Indeed, the communication between the development computer and the end-user computer is done via socket. This port can be modified in the HFConf.INI file.
• The user who handles the database must have:
  • the rights to debug the database,
  • the rights to debug any connection.

Mode 3: Debugging an existing connection

• The port used for debugging is port 27281 by default. This port must be opened if a firewall is used. Indeed, the communication between the development computer and the end-user computer is done via socket. This port can be modified in the HFConf.INI file.
• The user who handles the database must have:
  • the rights to debug the database,
  • the rights to debug any connection.