ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Managing the HFSQL contexts in the windows and in the reports
An HFSQL context contains information relative to the data used...
Remote HFSQL Administrator: Overview
The remote HFSQL administrator is a WEBDEV site installed with the WEBDEV application server and used to remotely manage the HFSQL Client/Server databases installed on the Web server...
DB2 Native Connector: Features and notes
The following paragraphs present the main aspects and specific features of the Native DB2 Connector...
Native Oracle Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer an optional Native Oracle Connector (also called Native Oracle Access...
Comparison operators
The comparison operators can be divided into several categories...
HQueryExecuted (Function)
Determines if a query has been executed.
FOR EACH/FOR ALL statement (loop through files)
The FOR EACH statement is used to run different types of HFSQL loops...
fDataDir (Function)
Returns the full path of the directory of HFSQL data files specified by the user when installing the application.
HListStopWord (Function)
Returns the list of stop words used by a full-text index.
<Source>.QueryExecuted (Function)
Determines if a query has been executed.
Native DB2 Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer an optional Native Connector to DB2...
HDeleteView (Function)
Deletes a previously created view. This function uses the former view mechanism.
HInfoMemo (Function)
Returns the characteristics of binary and text memos.
<Connection variable>.InfoUser (Function)
Updates the variables for user management with the information regarding the specified user.
Limitations of WINDEV, WEBDEV and WINDEV Mobile
Report based on a programmed data source
In a report on a programmed data source, the reading of the records that will be displayed...
WLanguage functions available in PHP
Some WLanguage functions are not available in PHP......
Running a query and handling the result in WLanguage
The selection of records performed by query is not necessarily displayed in a report, in a window, ......
WDSQL: Connecting to a database
The first operation to perform in order to use WDSQL is to establish the connection...
HInfoDatabaseRights (Function)
Allows you to find out the rights granted to a user or to a group on a database.
HInfoServerRights (Function)
Allows you to find out the rights granted to a user or group of users on a server.
Null (Property)
The Null property is used to: Assign NULL to the item for the current record. Find...
<Connection variable>.TransactionEnd (Function)
Validates the current transaction: the modifications performed on the data file since the start...
HExecuteScheduledBackup (Function)
Forces the execution of a scheduled backup.
HInfoUser (Function)
Updates the variables for user management with the information regarding the specified user.
HListConnection (Function)
Returns the list of connections currently described in the application.
<Connection variable>.TransactionCancel (Function)
If a transaction is in progress, cancels all the operations performed on the data files...
SQL statements
The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows......
CompositeKey (Property)
The CompositeKey property determines if an item is a composite key.
CtAccess (Property)
The CtAccess property is used to set the type of access to the data file when connecting...
CtInitialCatalog (Property)
The CtInitialCatalog property is used to get the default database defined for the access.
CtOLEDBProvider (Property)
The CtOLEDBProvider property is used to get and set the name of the OLE DB provider (also called...
CtUserName (Property)
The CtUserName property is used to set the username that will be used when connecting to a specific...
CtDescribedUserName (Property)
The CtDescribedUserName property is used to set the username that will be used when connecting...
LogFile (Property)
The LogFile property is used to determine if a data file is a log file.
FilteredItem (Property)
The FilteredItem property is used to identify the item that has a filter implemented by HFilter.