PC SOFT

WINDEV的在线文档

  • Overview
  • How do I 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
文档页面当前正在翻译。对于此延迟我们深表歉意。
您可以自愿地帮助我们翻译您想要的文档段落,然后只需通过以下地址与我们联系:info@cn.windev.com
产品
WinDevWebDev-服务器代码WebDev-浏览器代码WinDev Mobile报表和查询
平台
WindowsLinuxWindows MobileWindows PhoneWindows Store appsAndroidAndroid Widget iPhone/iPad
语言
JavaPHPAjax用户代码(MCU)外部语言
数据库
HFSQLHFSQL Client/Server存储过程HF 5.5OLE DBODBC本地访问

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 do I 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: clickamong the quick access buttons.
  3. Select "Project .. Test mode .. Debug on a HyperFileSQL C/S server".On the "项目" pane, in the "测试模式" group, expand "测试模式" and select "Debug on a HyperFileSQL server".On the "项目" pane, in the "测试模式" group, expand "测试模式" and select "Debug on a HFSQL server".
  4. In the next screen, 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: 模式为测试 returns .

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: 模式为测试 returns .