ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Managing the automatic identifiers when adding a record
When adding a record into a HyperFileSQL file (HAdd), three management modes are available for the automatic identifiers......
HListProvider (Function)
Returns the list of OLE DB providers and/or Native Connectors installed on the current computer....
Errors while managing data files
When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError......
HListREP (Function)
Returns the list of assignments for the data files handled by the current application, which means the list of physical files corresponding to the files described in the analysis.
REP files
REP files contain the list of data files handled by the application....
HListItem (Function)
Returns the list of items: found in a data file ( a query or a view) known to the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account. found in a Record variable....
HFSQL data files exceeding 2 gigabytes
By default, the HFSQL engine allows you to manage large data files (up to 2 gigabytes)......
HListTrigger (Function)
Returns the list of triggers applied to one or more HFSQL data files.
Assisted HFSQL error handling
WINDEV, WEBDEV and WINDEV Mobile include a module for assisted management of HFSQL errors......
NULL values in HFSQL
WINDEV, WEBDEV and WINDEV Mobile allow you to manage the NULL value in the items of HFSQL data files and for all the other types of accesses (Native, OLE DB, ......
HReadLast (Function)
Sets the position on the last record of a data file according to a browse item.
Managing space characters in the searches?
ODBC driver for HFSQL Classic and for HFSQL Client/Server (Windows)
The ODBC driver for HFSQL Classic (single-user or multi-user) is used to access an HFSQL Classic database from an external database software that supports the accesses by ODBC......
The log process
...A log is a special file that contains the history of all changes made to one or more data files over a given period of time (date the file was created, last automatic data modification, last backup created with WDLog, etc.)...
Structure of log files (HFSQL Classic)
The following files are automatically created when logging an HFSQL Classic data file......
Aliases on data files: HAlias
The aliases are used to handle......
HReadNext (Function)
Sets the position on the next data file record according to a browse item.
Composite keys
A composite key is a key item containing several other items......
Filtering a data file, a view or a query
A filter is used to define by programming a selection of records corresponding to one or more criteria......
HMode (Function)
Changes the mode and the method for locking data files.
Application triggers
...A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ...) on a record of a data file....
HModify (Function)
Modifies the specified record or the record found in memory in the data file (query or view).
Automatic data file modification
The automatic data file modification updates the description of data files on user computers......
HNbRec (Function)
Returns the number of records in a file, query or HFSQL view: active records, crossed records, deleted records, etc.
Automatic data file modification: new date format
From WINDEV 7 and WEBDEV 7 version 149, new date and time formats are available for the Hyper File files......