|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| The CtOLEDBProvider property is used to get and set the name of the OLE DB provider (also called OLE DB server). |
|
|
|
|
|
|
|
| The CtDescribedDatabase property is used to set the OLE DB data source when connecting to a specific table via OLE DB. |
|
|
|
|
|
|
|
| The CtDescribedOLEDBProvider property is used to get and set the name of the OLE DB provider (also called OLE DB server). |
|
|
|
|
|
|
|
| The CtDatabase property is used to set the OLE DB data source when connecting to a specific table via OLE DB. |
|
|
|
|
|
|
|
| Returns the list of OLE DB providers and/or Native Connectors installed on the current computer. |
|
|
|
|
|
|
|
| Describes a new connection to an external database. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a web service proxy (SOAP). |
|
|
|
|
|
|
|
| Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string. |
|
|
|
|
|
|
|
| The CtDescribedCaption property is used to get and set the caption of the connection to the OLE DB data source. |
|
|
|
|
|
|
|
| Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string. |
|
|
|
|
|
|
|
| The User property is used to manage the user of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file. |
|
|
|
|
|
|
|
| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| The Provider property is used to manage the type of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| The CtDescribedUserName property is used to set the username that will be used when connecting to a specific table via OLE DB. |
|
|
|
|
|
|
|
| The Access property is used to manage the type of access of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| The Database property is used to manage databases associated with a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| The CtUserName property is used to set the username that will be used when connecting to a specific table via OLE DB. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|