|
|
|
|
|
|
|
|
|
|
|
|
|
|
| To handle a database via OLE DB, the following elements must be installed on the development computer and on the deployment computer... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed.... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Connects the current application to a database that must be interrogated via SQL. |
|
|
|
|
|
|
|
| Describes a new connection to an external database. |
|
|
|
|
|
|
|
| Returns the list of OLE DB providers and/or Native Connectors installed on the current computer. |
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a web service proxy (SOAP). |
|
|
|
|
|
|
|
| The CursorOptions property is used to manage the type of cursor used for a connection (Native Connectors, OLE DB, etc.). |
|
|
|
|
|
|
|
| The CtDescribedAccess property is used to set the type of access to the data file when connecting to a specific table via OLE DB. |
|
|
|
|
|
|
|
| The CtAccess property is used to set the type of access to the data file when connecting to a specific table via OLE DB. |
|
|
|
|
|
|
|
| The CtDescribedPassword property allows you to set the password used to open the data file in an OLE DB connection (file defined in the code only). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Begins, commits or rolls back a transaction:
on the files of a database opened by SQLConnect,
on the files of a database opened by a connection (OLE DB or Native Access/Native Connector) described in the data model editor or by HOpenConnection.... |
|
|
|
|
|
|
|
| The Password property can be used:
on the edit controls (or on the text table columns) to find out whether the control is a "Password" control or to modify the "Password" type of the control.
on the connections (HFSQL Client/Server, OLE DB, etc.) to define the password of the user who uses the connection.... |
|
|
|
|
|
|
|
| The Source property can be used on:
a Chart control: in this case, the Source property is used to get the source of the series: Table column, list of values, ...
a connection: in this case, the Source property is used to get or set the source of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| Returns the list of files:
found in the current analysis or in a specific analysis recognized by the HFSQL engine. The files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
available on a connection via a native access or via an OLE DB driver.
for a group of files defined in the data model editor.... |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile allow you to manage the NULL value in the items of HFSQL data files and for all the other types of accesses (Native, OLE DB, ...... |
|
|
|
|
|
|
|
| WDMap is a tool used to view and handle a data file while developing an application...... |
|
|
|
|
|
|
|
| Queries can be based on items from another query...... |
|
|
|
|
|
|
|
| The first operation to perform in order to use WDSQL is to establish the connection to a database...... |
|
|
|
|
|
|
|
| A script is a set of SQL commands used to perform a specific operation (create a new table in the database, insert records, ...... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose an optional Native Connector to Informix (also called Native Access...... |
|
|
|
|
|
|
|
| WDConver is a tool used to convert data to an HFSQL Classic data file from...... |
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code...... |
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
|
| Usage example of the HOpenConnection function |
|
|
|
|
|
|
|
| Usage example of the HChangeConnection function |
|
|
|
|
|
|
|
| Usage example of the SQLTransaction function |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|