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...
PageToFile (Function)
Automatically updates: the value of the items in a data file with the value of the controls...
HCopyRecord (Function)
Copies: the content of the current record (loaded in memory) to the current data file record....
FileToPage (Function)
Automatically updates the controls of a page with: the values of the bound items in the current...
MaxThumbnailWidth (Property)
The MaxThumbnailWidth property is used to get or change the maximum width of a thumbnail...
HHistoryModification (Function)
Returns the modifications performed on one or more items of a given record. The result can...
SQLCodeExecuted (Property)
The SQLCodeExecuted property gets the SQL code of a query after replacing the parameters...
HPrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order...
SourceFromPage (Function)
Automatically updates: the value of the items in a data file with the value of the controls...
Custom-Folders in the analysis
Several file descriptions can be grouped into a "Custom-Folder"......
WDOptimizer: Overview
The different operations that can be performed with WDOptimizer are as follows......
SQL commands available in an SQL query
WINDEV allows you to easily run queries in SQL code......
HExecuteView (Function)
Runs a view that was created beforehand (can be used to refresh the view data for example)....
HIndex (Function)
Rebuilds the file index (".NDX" file).
KeySize (Property)
The KeySize property is used to set the characteristics of a text memo key item.
HInfoLog (Function)
Returns information about the server logs.
<Source>.ExecuteView (Function)
Runs a view that was created beforehand (can be used to refresh the view data for example)....
HSuggestKeyStart (Function)
Starts collecting information on executed queries.
HSuggestKeyEnd (Function)
Finishes collecting information on executed queries.
<Connection variable>.DeleteServerTrigger (Function)
Deletes a server trigger.
<Connection variable>.DescribeServerTrigger (Function)
Adds or modifies a server trigger.
<Connection variable>.EndNoDatabaseAccess (Function)
Re-allows the access (which means the connection) to one or more databases accessible via...
<Connection variable>.InfoViewRights (Function)
Allows you to find out the rights granted to a user or to a group on an SQL view...
<Connection variable>.NoDatabaseAccess (Function)
Denies all new connections to a database or to all databases.
<Connection variable>.ListDatabase (Function)
Lists the Client/Server databases associated with a connection....
<Connection variable>.InfoServer (Function)
Returns the specified information about the server.