ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Creating, generating and deploying a web service
WINDEV and WEBDEV allow you to directly generate web services that use the SOAP technology......
Native SQL Server Connector: Programming with SQL functions
The SQL functions can be used to handle the SQL Server database......
SQLExecWDR (Function)
Runs the SQL code of a query created in the query editor.
SQL selection conditions
To specify the selection conditions in an SQL query, you can use......
CalculatedDefaultValue (Property)
The CalculatedDefaultValue property is used to: Find out the SQL expression that defines the default value of an item. This item was defined in the data model editor or through programming. Define the SQL expression that returns the default value of an item (item described through programming only)....
CalculatedItemExpression (Property)
The CalculatedItemExpression property is used to: Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or through programming. Define the SQL expression returning the value of a calculated item (when describing the item through programming)....
Generating SQL scripts
The content of an analysis can be exported in the format of SQL scripts for a specified database (SQL Server, Oracle, ......
WDModFic : Tool for automatic modification of data files
WDModFic is a tool used to perform the automatic modification of the data files found on the development computer and on the end-user computers......
Installing version 2024
Cherche les éléments d'un noeud HTML correspondant à une balise....
Transactions in SQL
Starting with version 21, you can manage transactions in SQL code......
SQLConnect (Function)
Connects the current application to a database that must be interrogated via SQL.
Analysis: Describing data files
The analysis is used to define the structure of data files used by the project......
HModifyViewRights (Function)
Modifies the rights granted to a user or to a group on a SQL view or on a materialized view.
<Connection variable>.ModifyViewRights (Function)
Modifies the rights granted to a user or group on an SQL view or on a materialized view.
SQLInfo (Function)
Initializes the different SQL variables with information relative to the last query run.
H.SQLServerMode (Variable)
Allows you to specify the version of the Native SQL Server Connector that will be used.
SQLCodeExecuted (Property)
The SQLCodeExecuted property gets the SQL code of a query after replacing the parameters with a value.
WDSQL: Creating and running a script
A script is a set of SQL commands used to perform a specific operation (create a new table in the database, insert records, ......
SQLConnectWS (Function)
Connects the current application to a database that will be queried by SQL through a Webservice proxy (SOAP).
HInfoViewRights (Function)
Allows you to find out the rights granted to a user or to a group on an SQL view or on a materialized view.
<Connection variable>.InfoViewRights (Function)
Allows you to find out the rights granted to a user or to a group on an SQL view or on a materialized view.
Creating an insert query
An insert query (corresponding SQL statement......
Managing Hive databases
Hive is a software layer of Hadoop used to run queries......
SQL set operations: UNION, UNION ALL and INTERSECT
SQL allows performing set operations on groups of files......
Native SQL Server Connector: Specific features and remarks
The following paragraphs present the main aspects and specific features of the Native SQL Server Connector......