• 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.

Testing an HFSQL Client/Server connection

1. Open the desired project in the editor.
2. Display the analysis linked to the project: click in the quick access buttons.
3. On the "Project" tab, in the "Test mode" group, expand "Test mode" and select "Debug on an 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 handles the database must have the rights to debug 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.