ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

HFSQL Client/Server: Port management
The ports used by the HFSQL Client/Server server......
SQLExecWDR (Function)
Runs the SQL code of a query created in the query editor.
SQL query (WLanguage type)
The "SQL query" type is used to write an SQL query in the WLanguage code.
CoordinateEditorToScreen (Function)
Converts a size or a position specified in the reference dpi in the editor (160 dpi) to the native dpi of screen on the device where the application is run.
CoordinateScreenToEditor (Function)
Converts a size or a position specified in the native dpi of the screen on the device where the application is run to the reference dpi in the editor (160 dpi).
ContactCreate (Function)
Displays the window for contact creation of the native application for contact management found on the device (Android, iPhone or iPad, Universal Windows).
Rights on the virtual directory
The HTMLEdit property is used to: find out whether a Word Processing control is displayed in optimized mode for HTML editing, modify a Word Processing control to display it (or not) in optimized mode for HTML editing....
hScheduling (Type of variable)
The hScheduling type is used to define and find out the characteristics of the scheduling that must be performed: for a scheduled optimization task of HFSQL Client/Server files. for a scheduled backup task of HFSQL Client/Server files. for a scheduled replication of HFSQL servers....
<Connection variable>.ModifyViewRights (Function)
Sets the rights granted to a user or group on an SQL view or on a materialized view.
<Connection variable>.InfoViewRights (Function)
Gets the rights granted to a user or group on an SQL view or on a materialized view.
How to create and run an SQL query through programming?
This help page explains how to create and run an SQL query through programming....
SQL functions for handling spatial data
Below are the main SQL functions that can be used to handle spatial data in SQL queries......
SQL: Managing joins (INNER JOIN, OUTER JOIN)
To select records coming from several data files, joins must be used in the SQL query......
NULL values in HFSQL
WINDEV, WEBDEV and WINDEV Mobile allow you to manage the NULL value in the items of the HFSQL data files and for all the other types of accesses (Native, OLE DB, ......
HInfoViewRights (Function)
Gets the rights granted to a user or group on an SQL view or on a materialized view.
Native MariaDB Connector: Specific features
The Native MariaDB Connector creates "InnoDB" tables to support locks and transactions on a MariaDB database......
HModifyViewRights (Function)
Modifies the rights granted to a user or to a group on a SQL view or on a materialized view.