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...
HTransactionInProgress (Function)
Used to find out whether a transaction is in progress.
Data model editor: the different types of items
The different types of items proposed in the data model editor are as follows:
HStatCalculate (Function)
Performs various statistical calculations on the file keys.
HLast (Function)
Sets the position on the last record of a data file according to a browse item.
HRead (Function)
Reads a record in a file according to a given record number.
<Source>.Read (Function)
Reads a record in a file according to a given record number.
<Source>.ErrorStatusModification (Function)
Returns the status of a record during a modification conflict.
<Source>.FilterStartsWith (Function)
Defines and enables a "Start with" filter on a file, view or query.
<Source>.FilterIncludedBetween (Function)
Defines and enables an "Included between" filter on a file, view or query.
Date (Property)
The Date property is used to: Retrieve the date from a DateTime variable. Modify the date...
HErrorStatusModification (Function)
Returns the status of a record during a modification conflict.
WDSQL: Exporting and printing the result of an SQL query
The result of a select query can be......
WINDEV concepts
Minute (Property)
The Minute property is used to: Retrieve the minutes from a Time or DateTime variable,...
<Source>.ChangeKey (Function)
Changes the browse item.
<Source>.Version (Function)
Used to find out: whether the content of a file was modified. whether the content of a file...
<Source>.ReadSeekFirst (Function)
Sets the position on the first record whose value for a specific item is strictly equal to a sought...
<Source>.Previous (Function)
Positions on the previous file record according to a browse item.
Native Sybase Connector for WINDEV and WEBDEV
WINDEV and WEBDEV propose an optional Native Connector to Sybase (also called Native Access...
<Source>.Add (Function)
Add: the record found in memory into the data file (query or view). the record found...
HFilterStartsWith (Function)
Defines and enables a "Start with" filter on a file, view or query.
HFilterIncludedBetween (Function)
Defines and enables an "Included between" filter on a file, view or query.
HOptimizeQuery (Function)
Optimizes the Select queries by using idle times when handling an application (period without...
WDSQL: Creating an SQL query
Once the connection to the database is established, WDSQL allows you to create different types...
WDSQL: Creating and running a script
A script is a set of SQL commands used to perform a specific operation (create a new table...