ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

Native MySQL Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer a Native Connector for MySQL...
MySQL Native Connector: Programming with HFSQL functions
To use a MySQL database with the Native Connector (or Native Access), import the structure of MySQL tables into the WINDEV or WEBDEV database schema...
HSetREP (Function)
Enables or disables the management of .REP file.
HActivateTrigger (Function)
Re-enables a trigger that was disabled by HDeactivateTrigger.
<Source>.Open (Function)
Opens a data file.
HDeactivateTrigger (Function)
Disables a trigger.
HListREP (Function)
Returns the list of assignments for the tables handled by the current application, which means the list of physical files corresponding to the files described in the database schema.
HClose (Function)
Closes either a table or all tables opened by the current user: all corresponding physical tables are closed for the current user.
HErrorIntegrity (Function)
Used to check whether an integrity error occurred.
<Polygon2D variable>.IsValid (Function)
Checks whether the specified 2D polygon is valid according to the OGC rules.
Link functions
Link functions are used to link the interface with the tables and vice versa. These functions are as follows:...
<Source>.ReadSeek (Function)
Sets the position on the first record whose value for a specific item is greater than or equal to a sought value (generic search).
HToItem (Function)
Assigns the specified value to an item of the current record.
HChangeKey (Function)
Changes the browse item.
Filters in table fields linked to a table
To filter the records displayed in a Table control linked to a table, WINDEV, WEBDEV and WINDEV Mobile offer several options......
TableDisplay (Function)
Refreshes a Table or TeeeView Table control from a given position: for a control linked to a file: changes made in the linked data file are reflected in the control. for a control handled programmatically: the calculated columns are re-calculated....
<Connection variable>.ExecuteScheduling (Function)
Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view.
<Source>.ListSynonym (Function)
Returns the list of synonyms used by a full-text index.
<Source>.FileExist (Function)
Determines: whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound). whether a view or a query was defined....
<Source>.ListStopWord (Function)
Returns the list of stop words used by a full-text index.
<Connection variable>.TransactionSavepoint (Function)
Declares a transaction savepoint.
HOptimizeQuery (Function)
Optimizes the Select queries by using idle times when handling an application (period without processes).
Composite keys
A composite key is a key item containing several other items......