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...
The "Analysis" pane
The "Analysis" pane lists......
Query with parameters
The queries with parameters allow the user to easily select records according to his own requirements......
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, ......
Native SQL Server Connector for WINDEV and WEBDEV 2024
QueueInfo (Function)
Retrieves the characteristics of a queue: types of elements and number of elements.
10. Embedded queries
<Queue variable>.Info (Function)
Retrieves the characteristics of a queue: types of elements and number of elements.
SQLTable (Function)
Transfers the result of a query to a Table control populated programmatically (a List Box or Combo Box control), with the possibility of Partial Fetch (the result is retrieved by blocks of rows).
Extensions of files created by WINDEV, WEBDEV, WINDEV Mobile
The table below presents the main extensions of files created and supported by WINDEV, WEBDEV and WINDEV Mobile......
Native SQL Server Connector license agreement
Native SQL Server Connector (also known as Native SQL Server Access) license agreement...
10. Embedded queries
10. Embedded queries
The controls from a window can be linked to a data file or existing query, ......
<Source>.Add (Function)
Add: the record found in memory into the data file (query or view). the record found in a Record variable into the data file (query or view)....
HAdd (Function)
Adds: the record found in memory into the data file (query or view). the record found in a Record variable into the data file (query or view)....
Queue, stack and list management functions
List of functions for managing the queues, the stacks and the lists...
Queue (Type of variable)
A Queue variable is a structured type that groups a set of elements of the same type.
iSkipPage (Function)
Generates a page break: the corresponding code is sent to the printer queue.
TreeView Table control based on a data file
This type of TreeView Table control is linked to a data file or query......
NbPendingThread (Property)
The NbPendingThread property is used to get the number of pending threads in a queue or in a stack.
iInitReportQueryConnection (Function)
Initializes the query linked to the report.
<Report>.InitQueryConnection (Function)
Initializes the query linked to the report.
<Source>.ExecuteQueryAsynchronous (Function)
Executes a SELECT query asynchronously.
Native SQL Server Connector: Retrieving the output value of a stored procedure
The Native SQL Server Connector is used to: specify the input values during the call to a stored procedure. retrieve the output values after a call to a stored procedure....
AdditionCompleted (Property)
The AdditionCompleted property determines if an element was added to a queue, list or stack, or if the operation is in progress.
ODBCPassword (Property)
The ODBCPassword property is used to: Identify the password used to connect to a database via an ODBC driver or a Native Connector. Specify the password used to connect to a database via an ODBC driver or a Native Connector....