| |
| <Connection variable>.CloseConnection | Closes a connection to a database. |
| <Connection variable>.FileExist | Finds out if a file exists, i.e. if it has been physically created (HCreation or HCreationIfNotFound). |
| <Connection variable>.InfoFile | Returns the characteristics of an HFSQL Classic or Client/Server data file. |
| <Connection variable>.OpenConnection | Opens a connection to a specific database. |
| <Connection variable>.RefreshView | Asks to recalculate the content of a materialized view. |
| <Connection variable>.RegenerateFile | Regenerates a data file from its log. |
| <Connection variable>.SetIntegrity | Enables or disables the management of an integrity constraint on a file link. |
| <Connection variable>.Transaction | Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. |
| <Connection variable>.TransactionCancel | If a transaction is in progress, cancels all the operations performed on the data files in transaction since the start of transaction. |
| <Connection variable>.TransactionEnd | Validates the current transaction: - the modifications performed on the data file since the start of transaction (<Connection variable>.TransactionStart) 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.
|
| <Connection variable>.TransactionStart | Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. |
| <Destination>.CopyRecord | Copies: - the content of the current record (loaded in memory) to the current data file record.
- the content of the Record variable to the current data file record.
|
| <HFSQL file>.ExportJSONString | Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string. |
| <Source>.ActivateAutoFilter | Enables an automatic filter on the linked files when browsing an XML file. |
| <Source>.ActivateFilter | Enables the filter that was previously created for the specified data file (view or query). |
| <Source>.Add | Add: - the record found in memory into the data file (query or view).
- the record found in a Record variable into the data file (query or view).
|
| <Source>.Alias | Creates a logical alias of a data file (or query) or cancels all existing aliases. |
| <Source>.Backward | Moves backward several records from the current position in the data file, according to a specified item. |
| <Source>.BuildKeyValue | Builds the value of a composite key to implement a filter (<Source>.Filter) or to perform a search (<Source>.ReadSeekFirst, <Source>.ReadSeekLast, etc.). |
| <Source>.CancelDeclaration | Allows you to: |
| <Source>.CancelSeek | Cancels the current search criterion. |
| <Source>.ChangeConnection | Dynamically changes the connection associated with a data file. |
| <Source>.ChangeDir | Changes the path to a data file (i.e. directory in which the file will be handled). |
| <Source>.ChangeKey | Changes the browse item. |
| <Source>.ChangeLocation | Modifies the search mode of physical data files (.FIC, .NDX, ...). |
| <Source>.ChangeLogDir | Modifies the location of log files corresponding to an HFSQL data file. |
| <Source>.ChangeName | Modifies the physical name of a data file. |
| <Source>.CheckIndex | Checks whether the data found in the index file (.NDX file) properly refers the data found in the data file (.FIC file). |
| <Source>.CheckMemo | Checks the structural integrity of memos in an HFSQL data file. |
| <Source>.CheckStructure | Defines the mode for comparing data files. |
| <Source>.CheckUnaltered | Checks whether one or all records in an unalterable data file have not been modified (with an hexadecimal editor for example). |
| <Source>.Close | Closes a data file or all the data files opened by the current user: all the corresponding physical data files are closed for the current user. |
| <Source>.CompareItem | Compares two values by sorting them according to the specified HFSQL index item: all the sort options specified for the item are taken into account (sensitivity to the case, to the punctuation, sort direction, Unicode language, ...). |
| <Source>.CreateView | Creates an HFSQL view.
This function uses the former view mechanism. |
| <Source>.Creation | Creates an empty data file (".FIC" extension) with the index file and the memo file if necessary. |
| <Source>.CreationIfNotFound | Performs the following operations: - If the file does not exist, creates an empty data file (".FIC" file) with the index file and the memo file if necessary. The function is equivalent to HCreation.
- If the file exists, opens the file.
|
| <Source>.Cross | Crosses a record in a data file. |
| <Source>.DataSourceKnown | Determines if a data source has been initialized. |
| <Source>.DeactivateAutoFilter | Disables an automatic filter on the linked files when browsing an XML file. |
| <Source>.DeactivateFilter | Temporarily disables the filter on a data file (view or query). |
| <Source>.Declare | Declares a description of data file (found in an analysis) in the current project. |
| <Source>.DeclareExternal | Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
| <Source>.Delete | Deletes a record from a data file (query or view). |
| <Source>.DeleteAll | Deletes all records from a data file, an HFSQL view or a query. |
| <Source>.DeleteTrigger | Deletes a trigger. |
| <Source>.DeleteView | Deletes a previously created view. This function uses the former view mechanism. |
| <Source>.DescribeFile | Describes a data file programmatically. |
| <Source>.DescribeTrigger | Adds or modifies a trigger on an HFSQL data file. |
| <Source>.DuplicateRecord | Duplicates the record read in a data file: the record found in memory is added into the data file (query or view). |
| <Source>.EndNoModif | Unlocks a file that was locked by the same program with <Source>.NoModif. |
| <Source>.ErrorModification | Returns the value of a record item when a modification conflict occurs.. |
| <Source>.ErrorStatusModification | Returns the status of a record during a modification conflict. |
| <Source>.ExecuteQuery | Declares a query created in the query editor to the HFSQL engine and runs this query. |
| <Source>.ExecuteQueryAsynchronous | Executes a SELECT query asynchronously. |
| <Source>.ExecuteSQLQuery | Initializes a query written in SQL language and declares this query to the HFSQL engine. |
| <Source>.ExecuteSQLQueryAsynchronous | Executes an SQL query asynchronously. |
| <Source>.ExecuteView | Runs a view that was created beforehand (can be used to refresh the view data for example). This function uses the former view mechanism. |
| <Source>.ExportCSV | Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file. |
| <Source>.ExportJSON | Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file. |
| <Source>.ExportXLS | Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
| <Source>.ExportXML | Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. |
| <Source>.ExtractMemo | Extracts the content of a binary memo item from an HFSQL file, a query or an HFSQL view to a physical file (on disk). |
| <Source>.FileExist | Determines:- whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound).
- whether a view or a query was defined.
|
| <Source>.Filter | Defines and enables a filter on a data file, view or query. |
| <Source>.FilterContains | Defines and enables a "Contains" filter on a data file, view or query. |
| <Source>.FilterIdentical | Defines and enables a filter used to find the exact value of a string item. |
| <Source>.FilterIncludedBetween | Defines and enables an "Included between" filter on a file, view or query. |
| <Source>.FilterStartsWith | Defines and enables a "Start with" filter on a file, view or query. |
| <Source>.First | Sets the position on the first record of a data file according to the specified browse item. |
| <Source>.Flush | Forces the operating system of the computer where the data files are found to write data onto the disk. |
| <Source>.Forward | Moves several records forward from the current position in the data file, according to a specified item. |
| <Source>.Found | Checks whether the current record corresponds to the current filter or search. |
| <Source>.Free | Transforms the crossed records (<Source>.Cross) into deleted records. |
| <Source>.FreeQuery | Free the resources of a query (after the call to <Source>.ExecuteQuery or <Source>.ExecuteSQLQuery). |
| <Source>.FTListWord | Lists the words of the current record that will be taken into account by the full-text indexing. |
| <Source>.GetCurrentPosition | Returns the approximate position of current record in the data file. |
| <Source>.HistoryModification | Returns the modifications performed on one or more items of a given record. The result can be displayed in a list box or in a table to allow the user to view the modifications made to the specified file. |
| Imports a CSV file into a data file in HFSQL Classic or Client/Server format (data file described in the analysis editor, or declared by the <Source>.Declare, <Source>.DeclareExternal or HDecritFile functions). |
| <Source>.ImportHF55 | Imports a Hyper File 5.5 file into an HFSQL Classic file. |
| <Source>.ImportJSON | Imports a JSON file into a data file in HFSQL Classic format (data file described in the data model editor or declared by <Source>.Declare, <Source>.DeclareExternal or <Source>.DescribeFile). |
| <Source>.ImportText | Imports a Text file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by <Source>.Declare, <Source>.DeclareExternal or <Source>.DescribeFile). |
| <Source>.ImportXLS | Imports an XLS file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by <Source>.Declare, <Source>.DeclareExternal or HDescribeFile). |
| <Source>.ImportXML | Imports an XML file into an HFSQL Classic or Client/Server data file (data file described in the data model editor or declared by <Source>.Declare, <Source>.DeclareExternal or <Source>.DescribeFile). |
| <Source>.Index | Rebuilds the file index (".NDX" file). |
| <Source>.IndexingInProgress | Indicates that a reindex operation is currently performed on an HFSQL data file and returns the percentage of reindexing already performed. |
| <Source>.InfoFile | Returns the characteristics of an HFSQL Classic or Client/Server data file. |
| <Source>.InfoMemo | Returns the characteristics of binary and text memos. |
| <Source>.InitSubscriber | Initializes the range of automatic identifiers for the description file of subscriber replica (".RPL" extension). |
| <Source>.JSONToRecord | Imports JSON data into the current record. |
| <Source>.Last | Sets the position on the last record of a data file according to a browse item. |
| <Source>.LinkMemo | Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item. |
| <Source>.ListFullTextIndex | Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
| <Source>.ListItem | Returns the list of items in a data file (query or view) recognized by the HFSQL engine. The data files defined by <Source>.Declare, <Source>.DeclareExternal and <Source>.DescribeFile are taken into account. |
| <Source>.ListKey | Returns the list of keys found in a data file (query or view) recognized by the HFSQL engine. |
| <Source>.ListLink | Returns the list of links (Merise type) found in the current analysis or in a specific analysis. |
| <Source>.ListQueryParameter | Returns the list of parameters for a query created in the query editor. |
| <Source>.ListSpatialKeys | Returns the spatial keys of a data file (used in a query or view) recognized by the HFSQL engine. |
| <Source>.ListStopWord | Returns the list of stop words used by a full-text index. |
| <Source>.ListSynonym | Returns the list of synonyms used by a full-text index. |
| <Source>.LockFile | Locks a data file and restricts the access to this data file for all other sites or applications. |
| <Source>.LockRecNum | Locks a record and restricts the access to this record for all the other applications. |
| <Source>.LogInfo | Adds comments to the log when saving the operation. |
| <Source>.LogRecreate | Used to re-create an empty log. |
| <Source>.LogRestart | Restarts the logging process on a file. |
| <Source>.LogStop | Stops the log process of a file. |
| <Source>.MergeView | Creates an HFSQL view from two previously created views (<Source>.CreateView). This function uses the former view mechanism. |
| <Source>.MigrateLinkedCompositeKey | Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. |
| <Source>.Mode | Changes the mode and the method for locking data files. |
| <Source>.Modify | Modifies the specified record or the record found in memory in the data file (query or view). |
| <Source>.ModifyStructure | Used to update the structure of an HFSQL data file by performing an automatic data modification (also called data synchronization). |
| <Source>.NbRec | Returns the number of records in a file, query or HFSQL view: active records, crossed records, deleted records, etc. |
| <Source>.Next | Sets the position on the next data file record according to a browse item. |
| <Source>.NoModif | Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy). |
| <Source>.OnError | Customizes the management of HFSQL errors. |
| <Source>.Open | Opens a data file. |
| <Source>.Optimize | Used to handle the idle periods of a software (period without processes) to optimize the queries and the browses that will be run thereafter. |
| <Source>.Out | Allows you to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query. |
| <Source>.Password | Defines the password used to create or open a data file. |
| <Source>.PrepareQuery | Initializes a query and declares this query to the database server in order to optimize the next executions of this query. |
| <Source>.PrepareSQLQuery | Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query. |
| <Source>.Previous | Positions on the previous file record according to a browse item. |
| <Source>.QueryExecuted | Determines if a query has been executed. |
| <Source>.Read | Reads a record in a file according to a given record number. |
| <Source>.ReadFirst | Sets the position on the first record according to a browse item. |
| <Source>.ReadLast | Sets the position on the last record of a data file according to a browse item. |
| <Source>.ReadNext | Sets the position on the next data file record according to a browse item. |
| <Source>.ReadPrevious | Sets the position on the previous record of a file according to a browse item. |
| <Source>.ReadSeek | Sets the position on the first record whose value for a specific item is greater than or equal to a sought value (generic search). |
| <Source>.ReadSeekFirst | Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search). |
| <Source>.ReadSeekLast | Sets the position on the last record whose value for a specific item is less than or equal to a sought value (exact-match search). |
| <Source>.RecNum | Returns:- the number of the current record in the HFSQL data file.
- the number of the current record in the HFSQL view.
|
| <Source>.RecordDate | Returns the date and time that an HFSQL record was last modified (Classic or Client/Server). |
| <Source>.RecordToJSON | Retrieves the structure and value of the current record and exports them into a string in JASON format. |
| <Source>.RecordToString | Converts the content of the current record to string (in a data file, HFSQL view, query, etc.). |
| <Source>.RecordToXML | Retrieves the structure and the value of the current record and exports them into a character string in XML format. |
| <Source>.Reset | Initialize: - one or all variables of file items with their default values.
- one or all items of a Record variable with their default values.
|
| <Source>.RestorePosition | Restores the context of a previously saved file (<Source>.SavePosition): current record, filter, pointers. |
| <Source>.RetrieveItem | Returns the content of an item found in the current record (in the data file, view, query, ...). |
| <Source>.RetrieveRecord | Returns the content of the current record (in a file, a view or a query, ...). |
| <Source>.Save | Modifies the current record if it exists, otherwise adds a new record. |
| <Source>.SavePosition | Stores the current file context: current record, filter, pointers. |
| <Source>.Security | Enables or disables the automatic security mechanism on one or more data files. |
| <Source>.Seek | Positions on the first record of the data file whose value for a specific item is greater than or equal to a search value (generic search by default). |
| <Source>.SeekFirst | Positions on the first file record whose value for a specific item is greater than or equal to a sought value. |
| <Source>.SeekLast | Sets the position on the last file record whose value for a specific item is less than or equal to a sought value. |
| <Source>.SetDuplicates | Enables or disables the management of duplicates on a unique key. |
| <Source>.SetLog | Enables or disables log management on a file. |
| <Source>.SetMemo | Used to modify the management mode of memo items. |
| <Source>.SetPosition | Sets the position on a record, based on the approximate position of one of its items. |
| <Source>.SetTransaction | Enables or disables the management of transactions for one or more files. |
| <Source>.SortView | Sorts an HFSQL view by creating an index on a view item. This function uses the former view mechanism. |
| <Source>.StatCalculate | Performs various statistical calculations on the file keys. |
| <Source>.StatDate | Returns the date of the last update for the index statistics. |
| <Source>.State | Used to find out the state of a record. |
| <Source>.StatNbDuplicates | Returns the number of duplicates for a given key item. |
| <Source>.StatNbRec | Returns the number of entries for a given key item. |
| <Source>.StatNbRecRange | Returns an estimate regarding the number of entries for a given key item in a given interval of values. |
| <Source>.StatTime | Returns the time of the last update for the index statistics. |
| <Source>.ToFile | Copies a data source (file, query, view, ...) to a physical HFSQL file with the same description. This file is neither encrypted nor password protected. |
| <Source>.ToItem | Assigns the specified value to an item of the current record. |
| <Source>.TransactionFree | Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction. |
| <Source>.UnlockFile | Unlocks the records of a data file: |
| <Source>.UnlockRecNum | Unlocks a record locked by: |
| <Source>.Version | Used to find out:- whether the content of a file was modified.
- whether the content of a file used by a query was modified.
|
| <Source>.ViewToFile | Saves the modifications performed in an HFSQL view (by <Source>.Modify, <Source>.Delete or <Source>.Cross) in the corresponding data file. This function uses the former view mechanism. |
| <Source>.Write | Writes a record into a data file without updating the indexes corresponding to all keys used in the file. |