|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Returns the number of records in a file, query or HFSQL view: active records, crossed records, deleted records, etc. |
|
|
|
|
|
|
|
| Names and runs an SQL query. |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| The SynchroHFSQL property is used to:
get the refresh mode of a Table control based on a data file linked to an HFSQL Client/Server data file.
specify the refresh mode of a Table control based on a data file linked to an HFSQL Client/Server data file.... |
|
|
|
|
|
|
|
| Returns the content of an item found in the current record (in the data file, view, query, ...). |
|
|
|
|
|
|
|
| Transfers the result of a query to a Table control populated programmatically (a List Box or Combo Box control), with the possibility of Partial Fetch (the result is retrieved by blocks of rows). |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
| Modifies the specified record or the record found in memory in the data file (query or view). |
|
|
|
|
|
|
|
| Initializes a query and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| Customizes the management of HFSQL errors. |
|
|
|
|
|
|
|
| Returns the number of the last error triggered by the HFSQL engine. |
|
|
|
|
|
|
|
| Returns the list of triggers applied to one or more HFSQL data files. |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile include multiple methods to filter the records displayed in a Table control based on a data file...... |
|
|
|
|
|
|
|
| Sets the position on the last file record whose value for a specific item is less than or equal to a sought value. |
|
|
|
|
|
|
|
| Extracts the content of a binary memo item from an HFSQL file, a query or an HFSQL view to a physical file (on disk). |
|
|
|
|
|
|
|
| Used to find out the state of a record. |
|
|
|
|
|
|
|
| The Type property is used to get:
the type of element (data file or item) defined programmatically or in the data model editor, view or query.
the type of object.
the type of data held in a Variant.... |
|
|
|
|
|
|
|
| When developing an application for iOS (iPhone or iPad), WINDEV Mobile allows you to test the application being developed without having to recompile it on Mac, but directly on the iPhone or iPad...... |
|
|
|
|
|
|
|
| Moves several records forward from the current position in the data file, according to a specified item. |
|
|
|
|
|
|
|
| Synchronizes the master replica and the subscriber replica: the operations performed on one of the replicas are transferred into the other replica. |
|
|
|
|
|
|
|
| Usage example of the HOpenConnection function |
|
|
|
|
|
|
|
| The ExecutionCompleted property is used to determine whether the execution of a query or view (HFSQL Classic or Client/Server) is completed.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|