|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A Table control can be used to display the content of a table or query... |
|
|
|
|
|
|
|
| The Table allows users to easily view and enter data stored in memory or from a table, view or query... |
|
|
|
|
|
|
|
| When you design a quick prototype, you often create windows (or pages) without defining any tables... |
|
|
|
|
|
|
|
| The database schema allows you to define the structure of tables used by the project... |
|
|
|
|
|
|
|
| The "Table" keyword can correspond to... |
|
|
|
|
|
|
|
| Two types of directories can be configured when creating the executable... |
|
|
|
|
|
|
|
| Lists the users currently connected to one or more files handled by a Client/Server connection. |
|
|
|
|
|
|
|
| The Table control is available for Android and iOS applications... |
|
|
|
|
|
|
|
| A Looper control can be used to display the content of a table or query... |
|
|
|
|
|
|
|
| Forbids all the modifications on a table (for all the programs, including the one that requested the no-modification policy). |
|
|
|
|
|
|
|
| Starts monitoring write actions (add, modify or delete) performed on a table present on an HFSQL server. In case of modification, a specific procedure can be triggered. |
|
|
|
|
|
|
|
| Temporarily disables the filter on a table (view or query). |
|
|
|
|
|
|
|
| Describes a full-text index of table created programmatically. |
|
|
|
|
|
|
|
| Defines and enables a filter on a table, view or query. |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Cancels an alias that was declared beforehand by HAlias. |
|
|
|
|
|
|
|
| Adds or modifies a trigger on an HFSQL table. |
|
|
|
|
|
|
|
| Sets the position on the next table record according to a browse item. |
|
|
|
|
|
|
|
| Sets the position on the last record of a table according to a browse item. |
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| Returns the list of semantic keys present in a table, query or view supported by the HFSQL engine. |
|
|
|
|
|
|
|
| Sets the position on the next table record according to a browse item. |
|
|
|
|
|
|
|
| Sets the position on the last record of a table according to a browse item. |
|
|
|
|
|
|
|
| Stores the current context of a table: current record, filter, read pointers. |
|
|
|
|
|
|
|
| Sets the position on the first record of a table according to the specified browse item. |
|
|
|
|
|
|
|
Returns the list of table bindings (Merise type) present:- in the current database schema,
- in ongoing database schemas (projects with multiple database schemas).
- in a specific database schema.
|
|
|
|
|
|
|
|
| Lists the words of the current record that will be taken into account by the full-text indexing. |
|
|
|
|
|
|
|
| This feature is used to signal that a table cannot be modified after writing... |
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
| Defines a semantic index of a table created programmatically. |
|
|
|
|
|
|
|
| Adds or modifies a trigger on an HFSQL table. |
|
|
|
|
|
|
|
| Starts monitoring write actions (add, modify or delete) performed on a table present on an HFSQL server. In case of modification, a specific procedure can be triggered. |
|
|
|
|
|
|
|
| Closes one or all the tables opened by the current user. |
|
|
|
|
|
|
|
| Sets the position on a record, based on the approximate position of one of its items. |
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), view or query to a JSON file. |
|
|
|
|
|
|
|
| A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ...) on a record of a table. |
|
|
|
|
|
|
|
| The database schema proposes two types of Unicode items ... |
|
|
|
|
|
|
|
| Deletes a record from a table (query or view). |
|
|
|
|
|
|
|
| Returns the list of assignments for the tables handled by the current application, which means the list of physical files corresponding to the files described in the database schema. |
|
|
|
|
|
|
|
| After the execution of a read or write function in a table, used to find out whether an error caused by a wrong password occurred on this table.
|
|
|
|
|
|
|
|
| Returns the list of tables watched by HWatch. |
|
|
|
|
|
|
|
| Describes a table programmatically. |
|
|
|
|
|
|
|
Unlocks a record locked by: - HLockRecNum,
- a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).
|
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| Returns the list of synonyms used by a full-text index. |
|
|
|
|
|
|
|
| Returns the list of stop words used by a full-text index. |
|
|
|
|
|
|
|
| Writes a record into a table without updating the indexes corresponding to all keys used in the table. |
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), a view or a query to a CSV file. |
|
|
|
|
|
|
|
| Sets the position on the next table record according to a browse item. |
|
|
|
|
|
|
|
| Closes one or all the tables opened by the current user. |
|
|
|
|
|
|
|
| Sets the position on a record, based on the approximate position of one of its items. |
|
|
|
|
|
|
|
| Returns the full path of the directory of HFSQL tables specified by the user when installing the application. |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the table.
|
|
|
|
|
|
|
|
| Reads a record in a file according to a given record number. |
|
|
|
|
|
|
|
| Allows you to find out whether the record on which you want to be positioned is located outside the table, filter, view or query. |
|
|
|
|
|
|
|
| Temporarily disables the filter on a table (view or query). |
|
|
|
|
|
|
|
| Checks whether the current record corresponds to the current filter or search. |
|
|
|
|
|
|
|
| Checks that one or all records in an unalterable table have not been modified (e.g. with a hexadecimal editor). |
|
|
|
|
|
|
|
| Deletes a previously created view. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Returns the list of links (Merise) in the current database schema or in a specific database schema. |
|
|
|
|
|
|
|
| Checks that one or all records in an unalterable table have not been modified (e.g. with a hexadecimal editor). |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| Stores the current file context (current record, filter, pointers). |
|
|
|
|
|
|
|
| Reads a record in a file according to a given record number. |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile support NULL values in items of HFSQL tables and for all other types of access (Native, OLE DB... |
|
|
|
|
|
|
|
| Used to check whether a lock error occurred. |
|
|
|
|
|
|
|
| Used to check whether an integrity error occurred. |
|
|
|
|
|
|
|
| Converts the content of the current record to string (in a table, HFSQL view, query, etc.). |
|
|
|
|
|
|
|
| Exports the records from a table (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Returns the list of stop words used by a full-text index. |
|
|
|
|
|
|
|
| Deletes all records from a table, an HFSQL view or a query. |
|
|
|
|
|
|
|
Unlocks a record locked by: - HLockRecNum,
- a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).
|
|
|
|
|
|
|
|
| Sets the position on the previous record of the table according to a browse item. |
|
|
|
|
|
|
|
| Describes a file item programmatically. |
|
|
|
|
|
|
|
| Sets the position on the first record of a table according to the specified browse item. |
|
|
|
|
|
|
|
| Sets the position on the next table record according to a browse item. |
|
|
|
|
|
|
|
| Exports records from a table (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), view or query to a JSON file. |
|
|
|
|
|
|
|
| Describes a table programmatically. |
|
|
|
|
|
|
|
| Describes a link between two tables programmatically. |
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), a view or a query to a CSV file. |
|
|
|
|
|
|
|
| Stops watching a table on an HFSQL server. |
|
|
|
|
|
|
|
| Writes a record into a table without updating the indexes corresponding to all keys used in the table. |
|
|
|
|
|
|
|
| Forbids all the modifications on a table (for all the programs, including the one that requested the no-modification policy). |
|
|
|
|
|
|
|
| Sets the position on the last record of a table according to a browse item. |
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
| Returns the spatial keys of a table (used in a query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Sets the position on the previous record of the table according to a browse item. |
|
|
|
|
|
|
|
| Used to find out whether the record on which you want to be positioned is located outside the table, filter, view or query. |
|
|
|
|
|
|
|
| Returns the list of keys in a table (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
Unlocks the records of a table:- locked by HLockFile.
- individually locked by a locking read function.
|
|
|
|
|
|
|
|
| Exports records from a table (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| During the life of an application, items live and die... |
|
|
|
|
|
|
|
Creates an HFSQL view.
This function uses the former view mechanism. |
|
|
|
|
|
|
|
Unlocks the records of a table:- locked by HLockFile.
- individually locked by a locking read function.
|
|
|
|
|
|
|
|
| Exports the records from a table (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Returns the list of items: |
|
|
|
|
|
|
|
| Deletes a record from a table (query or view). |
|
|
|
|
|
|
|
Returns the list of files:- current database schema.
- database schemas in progress (projects with multiple database schemas).
- a specific database schema recognized by the HFSQL engine.
- available on a connection via a Native Connector or an OLE DB driver.
- for a group of files defined in the data model editor.
|
|
|
|
|
|
|
|
| Returns the list of synonyms used by a full-text index. |
|
|
|
|
|
|
|
| Ends the description of the structure of an xBase table programmatically. |
|
|
|
|
|
|
|
| Deletes all records from a table, an HFSQL view or a query. |
|
|
|
|
|
|
|
| Stops watching a table on an HFSQL server. |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the table.
|
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile propose different methods for describing a connection... |
|
|
|
|
|
|
|
| Sets the position on the last record of a table according to a browse item. |
|
|
|
|
|
|
|
| Returns the list of tables watched by HWatch. |
|
|
|
|
|
|
|
| Returns the spatial keys of a table (used in a query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
Initializes: - one or all variables of file items with their default values.
- one or all items of a Record variable with their default values.
|
|
|
|
|
|
|
|
| Returns the list of keys in a table (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Deletes a previously created view. This function uses the former view mechanism. |
|
|
|
|
|
|
|
Initializes: - one or all variables of file items with their default values.
- one or all items of a Record variable with their default values.
|
|
|
|
|
|
|
|
| Converts the content of the current record to string (in a table, HFSQL view, query, etc.).
|
|
|
|
|
|
|
|
| Defines and enables a filter on a table, view or query. |
|
|
|
|
|
|
|
| Sets the position on the previous record of a file according to a browse item. |
|
|
|
|
|
|
|
| Checks whether the current record corresponds to the current filter or search. |
|
|
|
|
|
|
|
| Exports the records from a table (HFSQL or OLE DB), view, or query to a JSON string. |
|
|
|
|
|
|
|
| Returns the list of semantic indexes for a table supported by the HFSQL engine. |
|
|
|
|
|
|
|
| Exports the records from a table (HFSQL or OLE DB), view, or query to a JSON string. |
|
|
|
|
|
|
|
| Sets the position on the previous record of a file according to a browse item. |
|
|
|
|
|
|
|
| Lists the words of the current record that will be taken into account by the full-text indexing. |
|
|
|
|
|
|
|
Creates an HFSQL view.
This function uses the former view mechanism. |
|
|
|
|
|
|
|
| When creating a report, the test of this report can be run from the report editor...... |
|
|
|
|
|
|
|
| Returns the full path of the selected element in a TreeView control. |
|
|
|
|
|
|
|
| The docParagraph type is used to handle the characteristics of a paragraph in a DOCX document. |
|
|
|
|
|
|
|
| Initializes the range of automatic identifiers for the description file of subscriber replica... |
|
|
|
|
|
|
|
| The HFConf.INI file is found at server root. This file is used to define several characteristics... |
|
|
|
|
|
|
|
| Disables an Automatic Application Feature (AAF) on a control, window or on the current application. |
|
|
|
|
|
|
|
| Deletes all appointments and resources from a Scheduler control. |
|
|
|
|
|
|
|
| The CtInitialCatalog property is used to get the default database defined for the access. |
|
|
|
|
|
|
|
| The use of SQL functions to handle Progress data does not require importing the file structure... |
|
|
|
|
|
|
|
| The MaxHeight property is used to get and change the maximum height of a control or window. |
|
|
|
|
|
|
|
| Selects one or more elements in a List Box, ListView or Combo Box control. |
|
|
|
|
|
|
|
| Modifies an element in a List Box, ListView or Combo Box control populated programmatically. |
|
|
|
|
|
|
|
| Used to find out the row or control located at specific position in the Looper control (X, Y). |
|
|
|
|
|
|
|
| The DisplayCurrency property gets and sets the currency used when entering or displaying values... |
|
|
|
|
|
|
|
| WINDEV Mobile tutorial: Developing an Android and iOS application Lesson 2 - Development - 30 min |
|
|
|
|
|
|
|
| To manage messages in the Project Management Hub, you can use the secure messaging tool included... |
|
|
|
|
|
|
|
| Each Gantt Chart control in a window has a default menu that is available to users...... |
|
|
|
|
|
|
|
| The User Macro-Codes are sections of WLanguage code allowing the end user to customize... |
|
|
|
|
|
|
|
| The different characteristics of a block can be viewed and/or modified in the description window... |
|
|
|
|
|
|
|
| "Password" items are used to securely store passwords by using a salt and a hash algorithm...... |
|
|
|
|
|
|
|
| The report editor allows you to create "Scheduler" reports.... |
|
|
|
|
|
|
|
| The generator of WINDEV skin templates is used to generate the necessary files for creating... |
|
|
|
|
|
|
|
| The CtExtendedInfo property is used to get the additional information inserted into database... |
|
|
|
|
|
|
|
| Starts the process to populate a Looper control programmatically. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|