|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 HLinkMemo function |
|
|
|
|
|
|
|
| Usage example of the HCreateView function |
|
|
|
|
|
|
|
| Usage example of the HExtractMemo function |
|
|
|
|
|
|
|
| Usage example of the HAdd function |
|
|
|
|
|
|
|
| Modifies the physical name of a data file. |
|
|
|
|
|
|
|
| Enables the filter that was previously created for the specified table (view or query). |
|
|
|
|
|
|
|
| Usage example of the SQLConnect function |
|
|
|
|
|
|
|
| Usage example of the HCloseConenction function |
|
|
|
|
|
|
|
| Returns the list of links (Merise) in the current database schema or in a specific database schema. |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the SQL Server database...... |
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the table. |
|
|
|
|
|
|
|
| Usage example of the SQLModify function |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is greater than or equal to a sought value (generic search). |
|
|
|
|
|
|
|
| Sets the position on the last record of a table according to a browse item. |
|
|
|
|
|
|
|
| Usage example of the HListKey function |
|
|
|
|
|
|
|
| Usage example of the HDeclare function |
|
|
|
|
|
|
|
| Usage example of the HErrorInfo function |
|
|
|
|
|
|
|
| Usage example of the HFileExist function |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|