|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 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 property ODBCUsername property 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 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 ODBCNameBase 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".
|
|
|
|
|
|
|
|
| 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 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... |
|
|
|
|
|
|
|
| ODBC driver for HFSQL Classic and HFSQL Client/Server - License agreement |
|
|
|
|
|
|
|
| The monitoring robot will attempt to connect to an external database (MySQL, SQL Server, ... |
|
|
|
|
|
|
|
| Usage example of the HConnect function |
|
|
|
|
|
|
|
| Usage example of the HCloseConenction function |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed.... |
|
|
|
|
|
|
|
| The installation package (or DVD, if provided) allows you to install ... |
|
|
|
|
|
|
|
| Allows you to specify the version of the Native SQL Server Connector that will be used. |
|
|
|
|
|
|
|
| List of SQL functions: Special cases |
|
|
|
|
|
|
|
| To use a Progress database with the Native Connector, you must... |
|
|
|
|
|
|
|
| By default, only the files found in the "List of setup files" window are installed on the user computers... |
|
|
|
|
|
|
|
| Usage example of the HOpenConnection function |
|
|
|
|
|
|
|
| The Provider property is used to manage the type of a connection (HFSQL Client/Server, OLE DB, etc.). |
|
|
|
|
|
|
|
| The database can be accessed via a web service... |
|
|
|
|
|
|
|
| The CtOLEDBProvider 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. |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| Automatically associates each column of the query result with a control or with a variable of the application. |
|
|
|
|
|
|
|
| The CtDescribedOLEDBProvider property gets and sets the name of the OLE DB provider (also called OLE DB server). |
|
|
|
|
|
|
|
| Usage example of the HDescribeConnection function |
|
|
|
|
|
|
|
| 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 ... |
|
|
|
|
|
|
|
| WDMap is used to view the records found in a data file... |
|
|
|
|
|
|
|
| List all the tables that can be accessed by the connected database system. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose an optional Native Connector to Informix (also called Native Access... |
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a web service proxy (SOAP). |
|
|
|
|
|
|
|
| To use an SQL Server database with the Native Connector (or "Native Access"), you can use SQL functions... |
|
|
|
|
|
|
|
| An HFSQL context contains information relative to the data used... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| The first operation to perform in order to use WDSQL is to establish the connection to a database... |
|
|
|
|
|
|
|
| WEBDEV allows you to create a PHP site that handles data files... |
|
|
|
|
|
|
|
| Usage example of the SQLConnect function |
|
|
|
|
|
|
|
| List of properties associated with a report |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native SQL Server Connector (also called Native SQL Server Access)... |
|
|
|
|
|
|
|
| WDMap is used to get various characteristics ... |
|
|
|
|
|
|
|
| Usage example of the HChangeConnection 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). |
|
|
|
|
|
|
|
| The use of SQL functions to handle Progress data does not require importing the file structure into the analysis... |
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| A WEBDEV Cluster is a set of servers (or server farm)... |
|
|
|
|
|
|
|
| Used to find out the number of records added, modified or deleted when running the last query of the current context.
|
|
|
|
|
|
|
|
| Contains the number of the physical record loaded in memory (which means the number of the last record read). |
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| Modifies the current connection. |
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Indicates whether the indexing window must be displayed during the automatic reindexing of HFSQL data files. |
|
|
|
|
|
|
|
| Utilisation dans la classe Thread - Accès en Lecture - Type : Booléen |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| To use an SQL Server database with Native Connector, the structure of SQL Server tables must be imported into the data model analysis... |
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| 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 analysis.
- analyses in progress (projects with multiple analyses).
- a specific analysis 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. |
|
|
|
|
|
|
|
| A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ... |
|
|
|
|
|
|
|
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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Goes to the next row (i.e next record) of the query result. |
|
|
|
|
|
|
|
| Before you start using WDConver, you must have... |
|
|
|
|
|
|
|
| Once the component has been created, tested and generated, it can be distributed to other developers... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc, ... |
|
|
|
|
|
|
|
| The queries are used to easily select the records coming from one or more files, matching one or more selection criteria, ... |
|
|
|
|
|
|
|
| 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 query editor allows you to run the test of query result... |
|
|
|
|
|
|
|
| The setup program creation wizard allows you to define all the settings of your setup program. |
|
|
|
|
|
|
|
| WDMap is a tool used to view and handle a data file while developing an application... |
|
|
|
|
|
|
|
| Describes a new connection to an external database. |
|
|
|
|
|
|
|
| Opens a connection to a specific database. |
|
|
|
|
|
|
|
| Utilisation dans la classe _edthymlStylePolice - Accès en Lecture + Ecriture - Type : Tous types |
|
|
|
|
|
|
|
| Prints a report created with the report editor. |
|
|
|
|
|
|
|
| The analysis allows you to define the structure of data files used by the project... |
|
|
|
|
|
|
|
| Prints a report created with the report editor. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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 data file 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... |
|
|
|
|
|
|
|
| External component in practice |
|
|
|
|
|
|
|
| Queries are used to easily select records in one or more data files... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|