ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

<Source>.PrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query.
Analysis: Import files into the analysis (external database, HFSQL files, etc.)
WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc....
Database access: summary
WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed.......
SQL : ORDER BY clause: Organizing the result of a query
The ORDER BY clause is used to sort the records selected by an SQL query......
SQL commands available in an SQL query
WINDEV allows you to easily run queries in SQL code......
HPrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query.
HUpdateView (Function)
Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server.
<Connection variable>.UpdateView (Function)
Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server.
SQL view
An SQL view is a virtual data source defined by an SQL query......
Materialized view
<Connection variable>.ModifyViewRights (Function)
Modifies the rights granted to a user or 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.
HModifyViewRights (Function)
Modifies the rights granted to a user or to a group on a SQL view or on a materialized view.
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.
Setup of the WEBDEV Application Server for Linux
The installation package (or DVD, if provided) allows you to install...
Setup of the WEBDEV Application Server for Linux
Utilisation dans la classe _edthymlStylePolice - Accès en Lecture + Ecriture - Type : Tous types
HListProvider (Function)
Returns the list of OLE DB providers and/or Native Connectors installed on the current computer....
SQLInfo (Function)
Initializes the different SQL variables with information relative to the last query run.
SQL: Managing joins (INNER JOIN, OUTER JOIN)
To select records coming from several data files, joins must be used in the SQL query......
HCloseConnection (Example)
Usage example of the HCloseConenction function
Optional connection information
When defining the connections in the data model editor or when defining the connections through programming, you have the ability to specifier the optional connection information......
HOpenConnection (Example)
Usage example of the HOpenConnection function
HChangeConnection (Example)
Usage example of the HChangeConnection function
WDSQL: Creating an SQL query
Once the connection to the database is established, WDSQL allows you to create different types of SQL queries......
Server (Property)
The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.)....
1
2
3
4
5
6
155
>