ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Report based on an SQL query with data accessed via a connection (ODBC, etc.)
A report based on an SQL query with data accessed via a connection can print records from a database accessible via a specific ODBC driver or via a Native Connector...
Overloading a WLanguage function or using a WLanguage function in an SQL query
WLanguage includes the "WL" keyword...
HSuggestKeyEnd (Function)
Finishes collecting information on executed queries.
SQL functions for accessing the external databases
List of SQL functions used to access the external databases
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HSuggestKeyStart (Function)
Starts collecting information on executed queries.
Cross-database queries
An SQL query can operate on different databases...
HExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
<Source>.ExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HSuggestKey (Function)
Returns a list of keys to add to data files to improve query performance.
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
Creating a query in SQL code
The query editor allows you to create a query by typing SQL code...
Environment of the report editor
Environment of the report editor...
Debugging a connection to an HFSQL server
The stored procedures and the triggers are debugged from the environment, with real execution on the server......
Native PostgreSQL Connector: Specific features and remarks
Remarks and specific features of Native PostgreSQL Connector......
VisibleEndUser (Property)
The VisibleEndUser property is used to: Find out whether an item is visible or not to the end users. This item was defined in the data model editor or programmatically. Define whether an item must be visible or not to the end users (item described programmatically only)....
2. Examples and components provided with WEBDEV
Environment of code editor
Debugging without debugger
In some cases, running a program or a site with or without the debugger can produce different results......
WINDEV concepts
HFSQL Client/Server: Scheduled tasks
The scheduled tasks are used to schedule automatic tasks......
<Connection variable>.ExecuteProcedure (Function)
Runs a stored procedure.
<Source>.FilterIdentical (Function)
Defines and enables a filter used to find the exact value of a string item.
HFilterIdentical (Function)
Defines and enables a filter used to find the exact value of a string item.
HClearWorkingDir (Function)
Clears and destroys the temporary directory previously created when HServerWorkingDir was executed.
3. Multi-criteria search
WINDEV Tutorial: WINDEV application: Managing data Lesson 3 - Multi-criteria search - 40 min
Operating mode of HFSQL application
A HFSQL application can operate in network mode or in Client/Server mode......
Testing a project: setting
By testing the project you can simulate how the application will run......
WINDEV Mobile concepts
HServerWorkingDir (Function)
Returns the path of a temporary directory on the HFSQL server.
Transactions in HFSQL Client/Server mode
To keep maximum compatibility between HFSQL Classic applications (single-user or multi-user) and HFSQL Client/Server applications, the transaction mechanism in HFSQL Client/Server mode is similar to the one in HFSQL Classic mode......
<Connection variable>.DeleteSet (Function)
Deletes a set of stored procedures from an HFSQL server.
HDeleteSet (Function)
Deletes a set of stored procedures from an HFSQL server.
HFSQL server replication
The replication between HFSQL servers consists in automatically replicating the data from server to server, in an asynchronous way......
Differences and specific features of an HFSQL Client/Server application
The management mode of data files may have to be adapted when using an HFSQL Client/Server application......
Client/Server: Connecting the client computers to the server
In order for the application to be able to handle the data files found on the HFSQL server, the connection that will be used by the application must be defined in the project......
<Connection variable>.UpdateSet (Function)
Creates or updates a set of procedures on an HFSQL server.