• test a stored procedure: only 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 on among the quick access buttons.
3. On the "Proyecto" tab, in the "Modo de prueba" group, expand "Modo de prueba" 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: Launch project and debug next database connections

• 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 future database connections 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.