PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • How to proceed?
  • Running the test of a HFSQL Client/Server connection
  • Mode 1: Starting the project and debugging the next connections to the database
  • Mode 2: Debugging the next connections to the database coming from a specific user for a specific application
  • Mode 3: Debugging an existing connection
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
The stored procedures and the triggers are debugged from the environment, with real execution on the server. You can:
  • 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.
This last case will be presented in this help page.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
How to proceed?

Running the test of a HFSQL Client/Server connection

To run the test of a HFSQL Client/Server connection:
  1. Open the requested project in the editor.
  2. Display the analysis linked to the project ("Project .. Load the analysis").Display the analysis linked to the project: click among the quick access buttons.
  3. Select "Project .. Test mode .. Debug on a HyperFileSQL C/S server".On the "Project" pane, in the "Test mode" group, expand "Test mode" and select "Debug on a HyperFileSQL server".On the "Project" pane, in the "Test mode" group, expand "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.
Three start modes are available:
  • 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

This option is used to:
  • 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.
To use this debug mode:
  • 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.
Notes:

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

This option allows you to debug the stored procedures and the triggers used from any connection that complies with the filter criteria. If the filter criteria are not restrictive enough, there may be too many calls to the debugger. The elements deployed on the server are run.
To use this debug mode:
  • 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.
Note: InTestMode returns False.

Mode 3: Debugging an existing connection

This option allows you to debug the stored procedures and the triggers used from an existing connection. The elements deployed on the server are run.
To use this debug mode:
  • 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.
Note: InTestMode returns False.
Minimum required version
  • Version 12
This page is also available for…
Comments
Click [Add] to post a comment