|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The use of SQL functions to manipulate Informix data does not require importing the file structure into the database schema... |
|
|
|
|
|
|
|
| The mathematical SQL functions that can be used on the queries written in SQL code are as follows... |
|
|
|
|
|
|
|
| The ORDER BY clause is used to sort the records selected by an SQL query... |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code... |
|
|
|
|
|
|
|
| The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows... |
|
|
|
|
|
|
|
| To specify the selection conditions in an SQL query, you can use... |
|
|
|
|
|
|
|
| To select records coming from several data files, joins must be used in the SQL query... |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)... |
|
|
|
|
|
|
|
| The use of SQL functions to handle DB2 data does not require importing the table structure into the database schema... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native DB2 Connector... |
|
|
|
|
|
|
|
| As an option, WINDEV and WEBDEV offer an Informix Native Connector (also known as Native Access... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Oracle Connector (also called Native Oracle Access... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Access Connector to MariaDB ... |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| WEBDEV allows a site to create and access a database created by the browser on the computer of the Web user in browser code.
|
|
|
|
|
|
|
|
| The table below presents the main extensions of files created and supported by WINDEV, WEBDEV and WINDEV Mobile... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Connector for MySQL... |
|
|
|
|
|
|
|
| Remarks and specific features of Native Informix Connector |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Connector to Progress ... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Connector to DB2... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native Connector to PostgreSQL... |
|
|
|
|
|
|
|
| ...WDReplic is a tool used to manage the replication of data between several computers that use... |
|
|
|
|
|
|
|
| New features in WINDEV/WEBDEV/WINDEV Mobile 28 presented in the New Features brochure.... |
|
|
|
|
|
|
|
| New features in WINDEV/WEBDEV/WINDEV Mobile 28 presented in the New Features brochure.... |
|
|
|
|
|
|
|
| Refreshes a Table or TeeeView Table control from a given position:
for a control linked... |
|
|
|
|
|
|
|
| When creating a report, the test of this report can be run from the report editor.
You also... |
|
|
|
|
|
|
|
| An Item Description variable is used to describe one or more items in a data file programmatically. |
|
|
|
|
|
|
|
| To associate a CDM (Conceptual Data Model) with a project, you must generate the associated LDM... |
|
|
|
|
|
|
|
| A Logical Data Model (LDM) is used to describe the data structures (files, items, ...... |
|
|
|
|
|
|
|
| Two methods can be used to pass parameters to a query with parameters used in a window... |
|
|
|
|
|
|
|
| The logical operators are as follows...... |
|
|
|
|
|
|
|
| Locks a record and restricts the access to this record for all the other applications. |
|
|
|
|
|
|
|
| WDTrans is a tool for canceling transactions...... |
|
|
|
|
|
|
|
| The method for developing a site for Linux is identical to the method for developing a site... |
|
|
|
|
|
|
|
| The "Live Data" is used to view the content of the data files in the controls currently created... |
|
|
|
|
|
|
|
| The MDL file is the file used to generate a RAD window...... |
|
|
|
|
|
|
|
| Remarks and specific features of the Native Oracle Connector... |
|
|
|
|
|
|
|
| List of constants used by the HFSQL functions.... |
|
|
|
|
|
|
|
| The Native Sybase Connector (also called Native Sybase Access) is used to:
specify the input... |
|
|
|
|
|
|
|
| You can print different technical documentations describing all the elements of the project... |
|
|
|
|
|
|
|
| In some cases, it may be useful to run the same query multiple times while modifying one... |
|
|
|
|
|
|
|
| In some cases, it may be useful to execute the same stored procedure multiple times by changing one... |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to fully manage HFSQL Classic data files...... |
|
|
|
|
|
|
|
| The different operations that can be performed with WDLog are as follows...... |
|
|
|
|
|
|
|
| WEBDEV allows you to specify that a site or a set of pages can operate in off-line mode (without... |
|
|
|
|
|
|
|
| The project description window allows you to configure various elements of your project...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|