ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

SQL commands available in an SQL query
WINDEV allows you to easily run queries in SQL code......
Server triggers
Server triggers are stored procedures executed by the server before or after a write operation performed on a database file......
NbKeyItem (Property)
The NbKeyItem property is used to get the total number of key items (including composite keys) in a record of: a file described in the data model editor, a file described through programming, an HFSQL view, a query....
HFSQL Control Center: Creating and executing a query
The HFSQL Control Center allows you to create a query based on the data files of the database currently displayed in the Control Center......
Native Oracle Connector: Programming with HFSQL functions
To use an Oracle database with the Native Connector, the structure of ORACLE tables must be imported into the WINDEV or WEBDEV analysis......
HFSQL in network mode on a server running Windows NT4, 2000, XP or 2003
The access speed to the data in network depends on several parameters (see the section......
Handling a dynamic programmatically
WINDEV allows you to handle Dynamic Tab controls with the TabXXX functions and with multiple WLanguage properties......
Telemetry: Installing the server
To use the telemetry, you must install on a computer......
Handling the external files
WINDEV, WINDEV Mobile and WEBDEV propose several functions allowing you to manage the external files from your WINDEV/WINDEV Mobile applications or from your WEBDEV sites......
Assisted HFSQL error handling
WINDEV, WEBDEV and WINDEV Mobile include a module for assisted management of HFSQL errors......
Notifications of an HFSQL server
A server may encounter problems without any user (or developer) noticing anything. For example: a scheduled task may fail, an automatic backup may fail, a node may become inactive in a HFSQL cluster, ......
HConnect (Function)
Redefines one or more connection parameters via Native Connector (Access, SQL Server, MySQL or Oracle) or via an OLE DB access on a specific table or set of tables.
Transactions in SQL
Starting with version 21, you can manage transactions in SQL code......
HClient structure
The HClient structure is used to......
Native DB2 Connector: Programming with HFSQL functions
To use a DB2 database with Native Connector, the structure of DB2 tables must be imported into the WINDEV or WEBDEV analysis......
nWDEvaluate: Evaluating the value of an element
Evaluating the value of an element......
Creating an executable: Data file directory
Two types of directories can be configured when creating the executable......
Native MySQL Connector: Specific features
The Native MySQL Connector (also called "Native MySQL Access") creates "InnoDB" tables to support locks and transactions on a MySQL database......
Management errors specific to Native Connectors
When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError......
Native MariaDB Connector: Programming with HFSQL functions
To use a MariaDB database with Native Connector, the structure of MariaDB tables must be imported into the WINDEV or WEBDEV analysis......
Check: Connectivity to the external databases (by ODBC)
The monitoring robot will attempt to connect to an external database (MySQL, SQL Server, ......
<Connection variable>.ModifyViewRights (Function)
Modifies the rights granted to a user or group on an SQL view or on a materialized view.
<Connection variable>.AddGroup (Function)
Adds a group of users.
<Connection variable>.AddUser (Function)
Adds a user to a database.
<Connection variable>.InfoViewRights (Function)
Allows you to find out the rights granted to a user or to a group on an SQL view or on a materialized view.