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...
How to create and run an SQL query through programming?
This help page explains how to create and run an SQL query through programming.
Overloading a WLanguage function or using a WLanguage function in an SQL query
WLanguage includes the "WL" keyword...
Creating a query in SQL code
The query editor allows you to create a query by typing SQL code...
HSuggestKeyEnd (Function)
Finishes collecting information on executed queries.
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
The "Analysis" pane
The "Analysis" pane lists......
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, ......
Query with parameters
The queries with parameters allow the user to easily select records according to his own requirements......
Native SQL Server Connector for WINDEV and WEBDEV 2024
QueueInfo (Function)
Retrieves the characteristics of a queue: types of elements and number of elements.
<Queue variable>.Info (Function)
Retrieves the characteristics of a queue: types of elements and number of elements.
10. Embedded queries
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).
Native SQL Server Connector license agreement
Native SQL Server Connector (also known as Native SQL Server Access) license agreement...
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......
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)....
10. Embedded queries
Queue, stack and list management functions
List of functions for managing the queues, the stacks and the lists...
iSkipPage (Function)
Generates a page break: the corresponding code is sent to the printer queue.
Queue (Type of variable)
A Queue variable is a structured type that groups a set of elements of the same type.
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....