|
|
|
|
|
|
|
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. |
|
|
|
|
|
|
WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc.... |
|
|
|
|
|
|
WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed....... |
|
|
|
|
|
|
The ORDER BY clause is used to sort the records selected by an SQL query...... |
|
|
|
|
|
|
WINDEV allows you to easily run queries in SQL code...... |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. |
|
|
|
|
|
|
Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. |
|
|
|
|
|
|
An SQL view is a virtual data source defined by an SQL query...... |
|
|
|
|
|
|
Modifies the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
Allows you to find out the rights granted to a user or to a group on an SQL view or on a materialized view. |
|
|
|
|
|
|
Modifies the rights granted to a user or to a group on a SQL view or on a materialized view. |
|
|
|
|
|
|
Allows you to find out the rights granted to a user or to a group on an SQL view or on a materialized view. |
|
|
|
|
|
|
The installation package (or DVD, if provided) allows you to install... |
|
|
|
|
|
|
Utilisation dans la classe _edthymlStylePolice - Accès en Lecture + Ecriture - Type : Tous types |
|
|
|
|
|
|
Returns the list of OLE DB providers and/or Native Connectors installed on the current computer.... |
|
|
|
|
|
|
Initializes the different SQL variables with information relative to the last query run. |
|
|
|
|
|
|
To select records coming from several data files, joins must be used in the SQL query...... |
|
|
|
|
|
|
Usage example of the HCloseConenction function |
|
|
|
|
|
|
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...... |
|
|
|
|
|
|
Usage example of the HOpenConnection function |
|
|
|
|
|
|
Usage example of the HChangeConnection function |
|
|
|
|
|
|
Once the connection to the database is established, WDSQL allows you to create different types of SQL queries...... |
|
|
|
|
|
|
The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|