|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Reinitializes the content of an Organization Chart control from its data source (HFSQL data file for example). |
|
|
|
|
|
|
|
| To handle a database via OLE DB, the following elements must be installed on the development computer and on the deployment computer... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed.... |
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a web service proxy (SOAP). |
|
|
|
|
|
|
|
| Describes a new connection to an external database. |
|
|
|
|
|
|
|
| Connects the current application to a database that must be interrogated via SQL. |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Returns the list of OLE DB providers and/or Native Connectors installed on the current computer. |
|
|
|
|
|
|
|
| The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| The property Access property lets you manage the type of access for a connection (HFSQL Client/Server, 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 CtDescribedAccess 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 a table in an OLE DB connection (only for tables defined programmatically). |
|
|
|
|
|
|
|
| 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 the 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...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|