|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| The ODBC driver on HFSQL Classic (single-user and multi-user) is used to access an HFSQL Classic database from an external database software that supports ODBC accesses... |
|
|
|
|
|
|
|
| The ODBC driver for HFSQL Classic (single-user or multi-user) is used to access an HFSQL Classic database from an external database software that supports the accesses by ODBC... |
|
|
|
|
|
|
|
| The ODBC driver on HFSQL Classic is used to access an HFSQL Classic database from an external database software that supports ODBC accesses... |
|
|
|
|
|
|
|
| The ODBC driver for HFSQL Classic (single-user or multi-user) is used to access an HFSQL Classic database from an external database software that supports the accesses by ODBC... |
|
|
|
|
|
|
|
The ODBCUserName property allows you to:- Identify the username used to connect to a database via an ODBC driver or a Native Connector.
- Specify the username used to connect to a database via an ODBC driver or a Native Connector.
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
The ODBCConnectionName property is used to:- Identify the name of the ODBC connection used when printing a report based on a "query performed on a connection".
- Specify the name of the ODBC connection used when printing a report based on a "query performed on a connection".
|
|
|
|
|
|
|
|
The ODBCCodeSQL property allows you to:- Find out the SQL code of the "query performed on a connection" (data source of report).
- Modify the SQL code of the "query performed on a connection" (data source of report).
|
|
|
|
|
|
|
|
The ODBCNomBase property allows you to:- Find out the name of the database used when printing a report based on a "query performed on a connection".
- Specify the name of the database used when printing a report based on a "query performed on a connection".
|
|
|
|
|
|
|
|
| The native access to HFSQL Classic and Client/Server is available for WINDEV applications running in Linux ("console" applications) and for the WEBDEV websites hosted in Linux... |
|
|
|
|
|
|
|
| The monitoring robot will attempt to connect to an external database (MySQL, SQL Server, ... |
|
|
|
|
|
|
|
| Usage example of the HConnect function |
|
|
|
|
|
|
|
| The TextColor property sets the text color of an element. |
|
|
|
|
|
|
|
| The installation package (or DVD, if provided) allows you to install ... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed.... |
|
|
|
|
|
|
|
| List of SQL functions: Special cases |
|
|
|
|
|
|
|
| Allows you to specify the version of the Native SQL Server Connector that will be used. |
|
|
|
|
|
|
|
| By default, only the files found in the "List of setup files" window are installed on the user computers... |
|
|
|
|
|
|
|
| To use a Progress database with the Native Connector, you must... |
|
|
|
|
|
|
|
| Usage example of the HOpenConnection function |
|
|
|
|
|
|
|
| The database can be accessed via a web service... |
|
|
|
|
|
|
|
| The Provider property is used to manage the type of a connection (HFSQL Client/Server, OLE DB, etc.). |
|
|
|
|
|
|
|
| The CtOLEDBProvider property gets and sets the name of the OLE DB provider (also called OLE DB server). |
|
|
|
|
|
|
|
| The CtDescribedOLEDBProvider property gets and sets the name of the OLE DB provider (also called OLE DB server). |
|
|
|
|
|
|
|
| Lists the data sources declared on a local site. |
|
|
|
|
|
|
|
| Automatically associates each column of the query result with a control or with a variable of the application. |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| Usage example of the HDescribeConnection function |
|
|
|
|
|
|
|
| WDMap is used to view the records found in a table... |
|
|
|
|
|
|
|
| The setup program creation wizard includes the setup of the database along with the application and suggests additional elements... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Connector to Progress ... |
|
|
|
|
|
|
|
| As an option, WINDEV and WEBDEV offer an Informix Native Connector (also known as Native Access... |
|
|
|
|
|
|
|
| An HFSQL context contains information relative to the data used... |
|
|
|
|
|
|
|
| To use an SQL Server database with the Native Connector (or "Native Access"), you can use SQL functions... |
|
|
|
|
|
|
|
| Connects the current application to a database that must be interrogated via SQL. |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SQL Server Connector... |
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a web service proxy (SOAP). |
|
|
|
|
|
|
|
| List all the tables that can be accessed by the connected database system. |
|
|
|
|
|
|
|
| WEBDEV allows you to create a PHP site that handles tables... |
|
|
|
|
|
|
|
| Updates the characteristics of a WEBDEV account in a WEBDEV Application Server. |
|
|
|
|
|
|
|
| Usage example of the HCloseConenction function |
|
|
|
|
|
|
|
| The first operation to perform in order to use WDSQL is to establish the connection to a database... |
|
|
|
|
|
|
|
| List of properties associated with a report |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native SQL Server Connector (also called Native SQL Server Access)... |
|
|
|
|
|
|
|
| Usage example of the SQLConnect 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). |
|
|
|
|
|
|
|
| Usage example of the HChangeConnection function |
|
|
|
|
|
|
|
| WDMap is used to get various characteristics ... |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| The use of SQL functions to handle Progress data does not require importing the file structure into the database schema |
|
|
|
|
|
|
|
| Temporarily imports into the current database schema the description of a table from an existing HFSQL table. |
|
|
|
|
|
|
|
| When defining the connections in the data model editor or when defining the connections programmatically, you have the ability to specifier the optional connection information... |
|
|
|
|
|
|
|
| Usage example of the HOut 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. |
|
|
|
|
|
|
|
| Redefines one or more connection parameters via Native Connector (Access, SQL Server, MySQL or Oracle) or via an OLE DB access on a specific table or set of tables. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| The monitor of the monitoring robot is used to create the different checks that must be performed by the monitoring robot... |
|
|
|
|
|
|
|
| Displays a WEBDEV frameset in the user's browser and closes all the current page and frameset contexts. |
|
|
|
|
|
|
|
| A WEBDEV Cluster is a set of servers (or server farm)... |
|
|
|
|
|
|
|
| Usage example of the SQLModify function |
|
|
|
|
|
|
|
| Usage example of the SQLFirst function |
|
|
|
|
|
|
|
| Contains the number of the physical record loaded in memory (which means the number of the last record read). |
|
|
|
|
|
|
|
| Used to find out the number of records added, modified or deleted when running the last query of the current context.
|
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| To use an Informix database with the Native Connector, import the structure of Informix tables into the WINDEV or WEBDEV analysis... |
|
|
|
|
|
|
|
| Temporarily imports into the current database schema the description of a table from an existing HFSQL table. |
|
|
|
|
|
|
|
| A script is a set of SQL commands used to perform a specific operation (create a new table in the database, insert records, ... |
|
|
|
|
|
|
|
| The different Windows versions propose standard regarding the location of some files and the use of directories... |
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| To use an SQL Server database with Native Connector, the structure of SQL Server tables must be imported into the data model database schema... |
|
|
|
|
|
|
|
| Indicates whether the indexing window must be displayed during the automatic reindexing of HFSQL tables. |
|
|
|
|
|
|
|
Used to lock:- The entire data table, in read and write mode. Its data cannot be accessed by other computers.
- The records selected by the query. This data cannot be accessed by the other computers. This method can be used to update records for example.
|
|
|
|
|
|
|
|
The Definition type is used to find out the characteristics of a type: - simple type,
- advanced type,
- class,
- structure.
|
|
|
|
|
|
|
|
| The OLE DB provider on HFSQL is used to access an HFSQL database (Classic or Client/Server) from an external software that manages the accesses by OLE DB... |
|
|
|
|
|
|
|
| Modifies the current connection. |
|
|
|
|
|
|
|
| A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ... |
|
|
|
|
|
|
|
| Usage example of the SQLExec function |
|
|
|
|
|
|
|
| Drag and Drop is used to transfer data between several controls with the mouse. This data can be moved between several controls found in the same application or in different applications. |
|
|
|
|
|
|
|
| Executes a stored procedure in asynchronous mode. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
Returns the list of files:- current database schema.
- database schemas in progress (projects with multiple database schemas).
- a specific database schema recognized by the HFSQL engine.
- available on a connection via a Native Connector or an OLE DB driver.
- for a group of files defined in the data model editor.
|
|
|
|
|
|
|
|
| Opens a connection to a specific Client/Server database to manage User Groupware files in Client/Server mode. |
|
|
|
|
|
|
|
This help page presents the different types of silent installation available:- WEBDEV Application Server installation.
- HFSQL Client/Server installation.
|
|
|
|
|
|
|
|
| Executes a stored procedure in asynchronous mode. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Goes to the next row (i.e next record) of the query result. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc, ... |
|
|
|
|
|
|
|
| Once the component has been created, tested and generated, it can be distributed to other developers... |
|
|
|
|
|
|
|
| Before you start using WDConver, you must have... |
|
|
|
|
|
|
|
| The queries are used to easily select the records coming from one or more files, matching one or more selection criteria, ... |
|
|
|
|
|
|
|
| Calculates the area of a polygon defined using geographic coordinates. |
|
|
|
|
|
|
|
| Project configurations allow you to adapt the same project to multiple "targets"... |
|
|
|
|
|
|
|
| List of properties associated with the reports and their controls |
|
|
|
|
|
|
|
| For compatibility with previous versions of the SQL Server Native Connector (also known as SQL Server Native Access), it is still possible to configure the connection in the WDSQSINS software (delivered with the SQL Server Native Connector)... |
|
|
|
|
|
|
|
| Opens a connection to a specific database. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Oracle Connector (also called Native Oracle Access... |
|
|
|
|
|
|
|
| For backward compatibility with the earlier versions of Native Oracle Connector (also called Native Oracle Access), the connection can still be configured in WDORAINS (supplied with Native Oracle Connector)... |
|
|
|
|
|
|
|
| The setup program creation wizard allows you to define all the settings of your setup program. |
|
|
|
|
|
|
|
| The query editor allows you to run the test of query result... |
|
|
|
|
|
|
|
| Deletes all the values from the local storage. |
|
|
|
|
|
|
|
| Describes a new connection to an external database. |
|
|
|
|
|
|
|
| WDMap is a tool used to view and handle a table while developing an application... |
|
|
|
|
|
|
|
| Opens a connection to a specific database. |
|
|
|
|
|
|
|
| Deletes a document from a collection in a MongoDB database. |
|
|
|
|
|
|
|
| Prints a report created with the report editor. |
|
|
|
|
|
|
|
| The database schema allows you to define the structure of tables used by the project... |
|
|
|
|
|
|
|
| Prints a report created with the report editor. |
|
|
|
|
|
|
|
| Moves a directory and its contents to another directory within a remote drive. |
|
|
|
|
|
|
|
| List of properties associated with the Progress Bar control |
|
|
|
|
|
|
|
| Queries can be based on items from another query... |
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| Queries are used to easily select records in one or more tables... |
|
|
|
|
|
|
|
| This chapter presents the configuration required to install WINDEV, WEBDEV or WINDEV Mobile in 64-bit mode... |
|
|
|
|
|
|
|
| WDConver is a tool used to convert data to an HFSQL Classic table from a file... |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Initializes a query and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| Initializes a query and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| The OAuth protocol is an open standard used to issue secure authorizations... |
|
|
|
|
|
|
|
| Callback from the PartageProximitéEnvoieFichier.Cb function for the Callback parameter |
|
|
|
|
|
|
|
| Définit l'image SVG utilisée pour un graphe de type "Pourcentage imagé". |
|
|
|
|
|
|
|
| External component in practice |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| List of constants used by the HFSQL functions. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| The "Logs" tab is used to see the details of logs for a specific period... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|