|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 must be interrogated via SQL. |
|
|
|
|
|
|
|
| Describes a new connection to an external database. |
|
|
|
|
|
|
|
| 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 will be queried by SQL through a web service proxy (SOAP). |
|
|
|
|
|
|
|
| Returns the list of OLE DB providers and/or Native Connectors installed on the current computer. |
|
|
|
|
|
|
|
| Usage example of the HNbRec function |
|
|
|
|
|
|
|
| Usage example of the HOnError function |
|
|
|
|
|
|
|
| WINDEV Tutorial - External database Using data from an external database - 40 min |
|
|
|
|
|
|
|
| Usage example of the HChangeName function |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the data file. |
|
|
|
|
|
|
|
| Usage example of the HMergeView function |
|
|
|
|
|
|
|
| Validates the current transaction:
the modifications performed on the table since the start of transaction (HTransactionStart) are validated.
the transaction file is deleted (if the transaction is the last transaction in progress for a network application)
the records locked in read-only by the transaction are unlocked.... |
|
|
|
|
|
|
|
| Usage example of the HListItem function |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Usage example of the HErrorDuplicates function |
|
|
|
|
|
|
|
| The assisted replication through programming is used to implement a replication on an existing application while controlling the synchronization in the application itself...... |
|
|
|
|
|
|
|
| Usage example of the SQLExec function |
|
|
|
|
|
|
|
| Usage example of the HChangeKey function |
|
|
|
|
|
|
|
| Usage example of the SQLFirst function |
|
|
|
|
|
|
|
| Changes the mode and the method for locking tables. |
|
|
|
|
|
|
|
| Stores the current file context (current record, filter, pointers). |
|
|
|
|
|
|
|
| Usage example of the HExecuteQuery function |
|
|
|
|
|
|
|
| Usage example of the HReadLast function |
|
|
|
|
|
|
|
| Usage example of the HExecuteSQLQuery function |
|
|
|
|
|
|
|
| Usage example of the HOut function |
|
|
|
|
|
|
|
| The CtExtendedInfo property gets the additional information inserted into the database connection string. |
|
|
|
|
|
|
|
| Usage example of the HModify function |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|