PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

New WINDEV, WEBDEV, WINDEV Mobile 25 feature!
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
The following functions are used to manage HFSQL data files (prefixed syntax):
<Connection variable>.CloseConnectionCloses a connection to a database.
Versions 25 and later
<Connection variable>.FileExist
<Connection variable>.FileExist
Finds out if a file exists, i.e. if it has been physically created (<Source>.Creation or <Source>.CreationIfNotFound).
Versions 25 and later
<Connection variable>.InfoFile
<Connection variable>.InfoFile
Returns the characteristics of an HFSQL Classic or Client/Server data file.
<Connection variable>.OpenConnectionOpens a connection to a specific database.
<Connection variable>.RefreshViewAsks to recalculate the content of a materialized view.
<Connection variable>.RegenerateFileRegenerates a data file from its log.
<Connection variable>.SetIntegrityEnables or disables the management of an integrity constraint on a file link.
<Connection variable>.TransactionStarts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file.
<Connection variable>.TransactionCancelIf a transaction is in progress, cancels all the operations performed on the data files in transaction since the start of transaction.
<Connection variable>.TransactionEndValidates the current transaction:
  • the modifications performed on the data file 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.
<Connection variable>.TransactionStartStarts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file.
Versions 25 and later
<HFSQL File>.SavePosition
New in version 25
<HFSQL File>.SavePosition
<HFSQL File>.SavePosition
Stores the current file context: current record, filter, pointers.
Versions 25 and later
<Source>.ActivateAutoFilter
<Source>.ActivateAutoFilter
Enables an automatic filter on the linked files when browsing an XML file.
Versions 25 and later
<Source>.ActivateFilter
New in version 25
<Source>.ActivateFilter
<Source>.ActivateFilter
Enables the filter that was previously created for the specified data file (view or query).
Versions 25 and later
<Source>.Add
New in version 25
<Source>.Add
<Source>.Add
Adds:
  • 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).
Versions 25 and later
<Source>.Alias
New in version 25
<Source>.Alias
<Source>.Alias
Creates a logical alias of data file (or query) or cancels all existing aliases.
Versions 25 and later
<Source>.Backward
New in version 25
<Source>.Backward
<Source>.Backward
Moves backward several records from the current position in the data file, according to a specified item.
Versions 25 and later
<Source>.BuildKeyValue
New in version 25
<Source>.BuildKeyValue
<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.).
Versions 25 and later
<Source>.CancelSeek
New in version 25
<Source>.CancelSeek
<Source>.CancelSeek
Cancels the current search criterion.
Versions 25 and later
<Source>.ChangeConnection
New in version 25
<Source>.ChangeConnection
<Source>.ChangeConnection
Dynamically changes the connection associated with a data file.
Versions 25 and later
<Source>.ChangeDir
New in version 25
<Source>.ChangeDir
<Source>.ChangeDir
Modifies the access path to a data file (which means the directory where the file will be used).
Versions 25 and later
<Source>.ChangeKey
New in version 25
<Source>.ChangeKey
<Source>.ChangeKey
Changes the search key.
Versions 25 and later
<Source>.ChangeLocation
New in version 25
<Source>.ChangeLocation
<Source>.ChangeLocation
Modifies the search mode of physical data files (.FIC, .NDX, ...).
Versions 25 and later
<Source>.ChangeLogDir
New in version 25
<Source>.ChangeLogDir
<Source>.ChangeLogDir
Modifies the location of log files corresponding to an HFSQL data file.
Versions 25 and later
<Source>.ChangeName
New in version 25
<Source>.ChangeName
<Source>.ChangeName
Modifies the physical name of a data file.
Versions 25 and later
<Source>.CheckIndex
New in version 25
<Source>.CheckIndex
<Source>.CheckIndex
Checks whether the data found in the index file (.NDX file) properly refers the data found in the data file (.FIC file).
Versions 25 and later
<Source>.CheckMemo
New in version 25
<Source>.CheckMemo
<Source>.CheckMemo
Checks the structural integrity of memos in an HFSQL data file.
Versions 25 and later
<Source>.CheckStructure
New in version 25
<Source>.CheckStructure
<Source>.CheckStructure
Defines the mode for comparing data files.
Versions 25 and later
<Source>.CheckUnaltered
New in version 25
<Source>.CheckUnaltered
<Source>.CheckUnaltered
Checks whether one or all records in an unalterable data file have not been modified (with an hexadecimal editor for example).
Versions 25 and later
<Source>.Close
New in version 25
<Source>.Close
<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.
Versions 25 and later
<Source>.CompareItem
New in version 25
<Source>.CompareItem
<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, ...).
Versions 25 and later
<Source>.CopyRecord
New in version 25
<Source>.CopyRecord
<Source>.CopyRecord
Copy:
  • the content of current record (loaded in memory) into the current record of a data file.
  • the content of Record variable into the current record of a data file.
Versions 25 and later
<Source>.CreateView
New in version 25
<Source>.CreateView
<Source>.CreateView
Creates an HFSQL view.
This function is using the former mechanism of views.
Versions 25 and later
<Source>.Creation
New in version 25
<Source>.Creation
<Source>.Creation
Creates an empty data file (".FIC" extension) with the index file and the memo file if necessary.
Versions 25 and later
<Source>.CreationIfNotFound
<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 <Source>.Creation.
  • If the file exists, opens the file.
Versions 25 and later
<Source>.Cross
New in version 25
<Source>.Cross
<Source>.Cross
Crosses a record in a data file.
Versions 25 and later
<Source>.DeactivateAutoFilter
<Source>.DeactivateAutoFilter
Disables an automatic filter on the linked files when browsing an XML file.
Versions 25 and later
<Source>.DeactivateFilter
New in version 25
<Source>.DeactivateFilter
<Source>.DeactivateFilter
Temporarily disables the filter on a data file (view or query).
Versions 25 and later
<Source>.Declare
New in version 25
<Source>.Declare
<Source>.Declare
Declares a description of data file (found in an analysis) in the current project.
Versions 25 and later
<Source>.DeclareExternal
New in version 25
<Source>.DeclareExternal
<Source>.DeclareExternal
Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file.
Versions 25 and later
<Source>.Delete
New in version 25
<Source>.Delete
<Source>.Delete
Deletes a record from a data file (query or view).
Versions 25 and later
<Source>.DeleteAll
New in version 25
<Source>.DeleteAll
<Source>.DeleteAll
Deletes all records from a data file, a HFSQL view or a query.
Versions 25 and later
<Source>.DeleteTrigger
New in version 25
<Source>.DeleteTrigger
<Source>.DeleteTrigger
Deletes a trigger.
Versions 25 and later
<Source>.DeleteView
New in version 25
<Source>.DeleteView
<Source>.DeleteView
Deletes a previously created view. This function is using the former mechanism of views.
Versions 25 and later
<Source>.DescribeFile
New in version 25
<Source>.DescribeFile
<Source>.DescribeFile
Describes a data file by programming.
Versions 25 and later
<Source>.DuplicateRecord
New in version 25
<Source>.DuplicateRecord
<Source>.DuplicateRecord
Duplicates the record read in a data file: the record found in memory is added into the data file (query or view).
Versions 25 and later
<Source>.EndNoModif
New in version 25
<Source>.EndNoModif
<Source>.EndNoModif
Unlocks a file that was locked by the same program with <Source>.NoModif.
Versions 25 and later
<Source>.ErrorModification
<Source>.ErrorModification
Returns the value of a record item when a modification conflict occurs..
<Source>.ErrorStatusModificationReturns the status of a record during a modification conflict.
Versions 25 and later
<Source>.ExportCSV
New in version 25
<Source>.ExportCSV
<Source>.ExportCSV
Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file.
Versions 25 and later
<Source>.ExportJSON
New in version 25
<Source>.ExportJSON
<Source>.ExportJSON
Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file.
Versions 25 and later
<Source>.ExportXLS
New in version 25
<Source>.ExportXLS
<Source>.ExportXLS
Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX).
Versions 25 and later
<Source>.ExportXML
New in version 25
<Source>.ExportXML
<Source>.ExportXML
Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file.
Versions 25 and later
<Source>.ExtractMemo
New in version 25
<Source>.ExtractMemo
<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).
Versions 25 and later
<Source>.FileExist
New in version 25
<Source>.FileExist
<Source>.FileExist
Allows you to find out:
Versions 25 and later
<Source>.Filter
New in version 25
<Source>.Filter
<Source>.Filter
Defines and enables a filter on a data file, view or query.
Versions 25 and later
<Source>.FilterContains
New in version 25
<Source>.FilterContains
<Source>.FilterContains
Defines and enables a "Contains" filter on a data file, view or query.
Versions 25 and later
<Source>.FilterIdentical
New in version 25
<Source>.FilterIdentical
<Source>.FilterIdentical
Defines and enables a filter used to find the exact value of a string item.
Versions 25 and later
<Source>.FilterIncludedBetween
<Source>.FilterIncludedBetween
Defines and enables an "Included between" filter on a file, view or query.
Versions 25 and later
<Source>.FilterStartsWith
New in version 25
<Source>.FilterStartsWith
<Source>.FilterStartsWith
Defines and enables a "Start with" filter on a file, view or query.
Versions 25 and later
<Source>.First
New in version 25
<Source>.First
<Source>.First
Sets the position on the first record of a data file according to the specified browse item.
Versions 25 and later
<Source>.Flush
New in version 25
<Source>.Flush
<Source>.Flush
Forces the operating system of the computer where the data files are found to write data onto the disk.
Versions 25 and later
<Source>.Forward
New in version 25
<Source>.Forward
<Source>.Forward
Moves several records forward from the current position in the data file, according to a specified item.
Versions 25 and later
<Source>.Found
New in version 25
<Source>.Found
<Source>.Found
Checks whether the current record corresponds to the current filter or search.
Versions 25 and later
<Source>.Free
New in version 25
<Source>.Free
<Source>.Free
Transforms the crossed records (<Source>.Cross) into deleted records.
Versions 25 and later
<Source>.FreeQuery
New in version 25
<Source>.FreeQuery
<Source>.FreeQuery
Free the resources of a query (after the call to <Fichier HFSQL>.ExécuteRequête or <Fichier HFSQL>.ExécuteRequêteSQL).
Versions 25 and later
<Source>.FTListWord
New in version 25
<Source>.FTListWord
<Source>.FTListWord
Lists the words of the current record that will be taken into account by the full-text indexing.
Versions 25 and later
<Source>.GetCurrentPosition
<Source>.GetCurrentPosition
Returns the approximate position of current record in the data file.
Versions 25 and later
<Source>.HistoryModification
<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.
Versions 25 and later
<Source>.ImportHF55
New in version 25
<Source>.ImportHF55
<Source>.ImportHF55
Imports a Hyper File 5.5 file into an HFSQL Classic file.
Versions 25 and later
<Source>.ImportJSON
New in version 25
<Source>.ImportJSON
<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).
Versions 25 and later
<Source>.ImportText
New in version 25
<Source>.ImportText
<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).
Versions 25 and later
<Source>.ImportXLS
New in version 25
<Source>.ImportXLS
<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).
Versions 25 and later
<Source>.ImportXML
New in version 25
<Source>.ImportXML
<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).
Versions 25 and later
<Source>.Index
New in version 25
<Source>.Index
<Source>.Index
Rebuilds the file index (".NDX" file).
Versions 25 and later
<Source>.IndexingInProgress
<Source>.IndexingInProgress
Indicates that a reindex operation is currently performed on a HFSQL data file and returns the percentage of reindexing already performed.
Versions 25 and later
<Source>.InfoFile
New in version 25
<Source>.InfoFile
<Source>.InfoFile
Returns the characteristics of an HFSQL Classic or Client/Server data file.
Versions 25 and later
<Source>.InfoMemo
New in version 25
<Source>.InfoMemo
<Source>.InfoMemo
Returns the characteristics of binary and text memos.
Versions 25 and later
<Source>.InitSubscriber
New in version 25
<Source>.InitSubscriber
<Source>.InitSubscriber
Initializes the range of automatic identifiers for the description file of subscriber replica (".RPL" extension).
Versions 25 and later
<Source>.Last
New in version 25
<Source>.Last
<Source>.Last
Sets the position on the last record of a data file according to a browse item.
Versions 25 and later
<Source>.LinkMemo
New in version 25
<Source>.LinkMemo
<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.
Versions 25 and later
<Source>.ListFullTextIndex
<Source>.ListFullTextIndex
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
Versions 25 and later
<Source>.ListItem
New in version 25
<Source>.ListItem
<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.
Versions 25 and later
<Source>.ListKey
New in version 25
<Source>.ListKey
<Source>.ListKey
Returns the list of keys found in a file (query or view) recognized by the HFSQL engine.
Versions 25 and later
<Source>.ListQueryParameter
<Source>.ListQueryParameter
Returns the list of parameters for a query created in the query editor.
Versions 25 and later
<Source>.ListStopWord
New in version 25
<Source>.ListStopWord
<Source>.ListStopWord
Returns the list of stop words used by a full-text index.
Versions 25 and later
<Source>.ListSynonym
New in version 25
<Source>.ListSynonym
<Source>.ListSynonym
Returns the list of synonyms used by a full-text index.
Versions 25 and later
<Source>.LockFile
New in version 25
<Source>.LockFile
<Source>.LockFile
Locks a data file and restricts the access to this data file for all other sites or applications.
Versions 25 and later
<Source>.LockRecNum
New in version 25
<Source>.LockRecNum
<Source>.LockRecNum
Locks a record and restricts the access to this record for all the other applications.
Versions 25 and later
<Source>.LogInfo
New in version 25
<Source>.LogInfo
<Source>.LogInfo
Adds comments into the log when saving the operation.
Versions 25 and later
<Source>.LogRecreate
New in version 25
<Source>.LogRecreate
<Source>.LogRecreate
Used to re-create an empty log.
Versions 25 and later
<Source>.LogRestart
New in version 25
<Source>.LogRestart
<Source>.LogRestart
Restarts the log process on a file.
Versions 25 and later
<Source>.LogStop
New in version 25
<Source>.LogStop
<Source>.LogStop
Stops the log process of a file.
Versions 25 and later
<Source>.MergeView
New in version 25
<Source>.MergeView
<Source>.MergeView
Creates an HFSQL view from two previously created views (<Source>.CreateView). This function is using the former mechanism of views.
<Source>.MigrateLinkedCompositeKeyMigrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format.
Versions 25 and later
<Source>.Mode
New in version 25
<Source>.Mode
<Source>.Mode
Changes the mode and the method for locking data files.
Versions 25 and later
<Source>.Modify
New in version 25
<Source>.Modify
<Source>.Modify
Modifies the specified record or the record found in memory in the data file (query or view).
Versions 25 and later
<Source>.ModifyStructure
New in version 25
<Source>.ModifyStructure
<Source>.ModifyStructure
Used to update the structure of an HFSQL data file by performing an automatic data modification (also called data synchronization).
Versions 25 and later
<Source>.NbRec
New in version 25
<Source>.NbRec
<Source>.NbRec
Returns the number of records in a file, a query or a HFSQL view: active records, crossed records, deleted records, etc.
Versions 25 and later
<Source>.Next
New in version 25
<Source>.Next
<Source>.Next
Sets the position on the next data file record according to a browse item.
Versions 25 and later
<Source>.NoModif
New in version 25
<Source>.NoModif
<Source>.NoModif
Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy).
Versions 25 and later
<Source>.OnError
New in version 25
<Source>.OnError
<Source>.OnError
Customizes the management of HFSQL errors.
Versions 25 and later
<Source>.Open
New in version 25
<Source>.Open
<Source>.Open
Opens a data file.
Versions 25 and later
<Source>.Optimize
New in version 25
<Source>.Optimize
<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.
Versions 25 and later
<Source>.Out
New in version 25
<Source>.Out
<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.
Versions 25 and later
<Source>.Password
New in version 25
<Source>.Password
<Source>.Password
Defines the password used to create or open a data file.
Versions 25 and later
<Source>.PrepareQuery
New in version 25
<Source>.PrepareQuery
<Source>.PrepareQuery
Initializes a query and declares this query to the database server in order to optimize the next executions of this query.
Versions 25 and later
<Source>.PrepareSQLQuery
New in version 25
<Source>.PrepareSQLQuery
<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.
Versions 25 and later
<Source>.Previous
New in version 25
<Source>.Previous
<Source>.Previous
Positions on the previous file record according to a browse item.
Versions 25 and later
<Source>.Read
New in version 25
<Source>.Read
<Source>.Read
Reads a record in a file according to a given record number.
Versions 25 and later
<Source>.ReadFirst
New in version 25
<Source>.ReadFirst
<Source>.ReadFirst
Sets the position on the first record according to a browse item.
Versions 25 and later
<Source>.ReadLast
New in version 25
<Source>.ReadLast
<Source>.ReadLast
Sets the position on the last record of a data file according to a browse item.
Versions 25 and later
<Source>.ReadNext
New in version 25
<Source>.ReadNext
<Source>.ReadNext
Sets the position on the next data file record according to a browse item.
Versions 25 and later
<Source>.ReadPrevious
New in version 25
<Source>.ReadPrevious
<Source>.ReadPrevious
Sets the position on the previous record of a file according to a browse item.
Versions 25 and later
<Source>.ReadSeek
New in version 25
<Source>.ReadSeek
<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).
Versions 25 and later
<Source>.ReadSeekFirst
New in version 25
<Source>.ReadSeekFirst
<Source>.ReadSeekFirst
Positions on the first file record whose value for a specific item is strictly equal to a sought value (exact-match search).
Versions 25 and later
<Source>.ReadSeekLast
New in version 25
<Source>.ReadSeekLast
<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).
Versions 25 and later
<Source>.RecNum
New in version 25
<Source>.RecNum
<Source>.RecNum
Returns:
  • the number of the current record in the HFSQL data file.
  • the number of the current record in the HFSQL view.
Versions 25 and later
<Source>.RecordDate
New in version 25
<Source>.RecordDate
<Source>.RecordDate
Returns the date and time of the last write operation performed on a record in an HFSQL file (Classic or Client/Server).
Versions 25 and later
<Source>.RecordToJSON
New in version 25
<Source>.RecordToJSON
<Source>.RecordToJSON
Retrieves the structure and value of the current record and exports them into a string in JASON format.
Versions 25 and later
<Source>.RecordToXML
New in version 25
<Source>.RecordToXML
<Source>.RecordToXML
Retrieves the structure and the value of the current record and exports them into a character string in XML format.
Versions 25 and later
<Source>.Reset
New in version 25
<Source>.Reset
<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.
Versions 25 and later
<Source>.RetrieveItem
New in version 25
<Source>.RetrieveItem
<Source>.RetrieveItem
Returns the content of an item found in the current record (in the data file, view, query, ...).
Versions 25 and later
<Source>.RetrieveRecord
New in version 25
<Source>.RetrieveRecord
<Source>.RetrieveRecord
Returns the content of the current record (in a file, a view or a query, ...).
Versions 25 and later
<Source>.Save
New in version 25
<Source>.Save
<Source>.Save
Modifies the current record if it exists, otherwise adds a new record.
Versions 25 and later
<Source>.Security
New in version 25
<Source>.Security
<Source>.Security
Enables or disables the automatic security mechanism on one or more data files.
Versions 25 and later
<Source>.Seek
New in version 25
<Source>.Seek
<Source>.Seek
Positions on the first record of the data file whose value for a specific item is greater than or equal to a sought value (generic search by default).
Versions 25 and later
<Source>.SeekFirst
New in version 25
<Source>.SeekFirst
<Source>.SeekFirst
Positions on the first file record whose value for a specific item is greater than or equal to a sought value.
Versions 25 and later
<Source>.SeekLast
New in version 25
<Source>.SeekLast
<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.
Versions 25 and later
<Source>.SetDuplicates
New in version 25
<Source>.SetDuplicates
<Source>.SetDuplicates
Enables or disables the management of duplicates on a unique key.
Versions 25 and later
<Source>.SetLog
New in version 25
<Source>.SetLog
<Source>.SetLog
Enables or disables log management on a file.
Versions 25 and later
<Source>.SetMemo
New in version 25
<Source>.SetMemo
<Source>.SetMemo
Used to modify the management mode of memo items.
Versions 25 and later
<Source>.SetPosition
New in version 25
<Source>.SetPosition
<Source>.SetPosition
Sets the position on a record, based on the approximate position of one of its items.
Versions 25 and later
<Source>.SetRemoteAccess
New in version 25
<Source>.SetRemoteAccess
<Source>.SetRemoteAccess
Temporarily disables the remote access in order to access HFSQL Classic data files found locally.
Versions 25 and later
<Source>.SetTransaction
New in version 25
<Source>.SetTransaction
<Source>.SetTransaction
Enables or disables the management of transactions for one or more files.
Versions 25 and later
<Source>.SortView
New in version 25
<Source>.SortView
<Source>.SortView
Sorts a HFSQL view by creating an index on a view item. This function is using the former mechanism of views.
Versions 25 and later
<Source>.StatCalculate
New in version 25
<Source>.StatCalculate
<Source>.StatCalculate
Performs various statistical calculations on the file keys.
Versions 25 and later
<Source>.StatDate
New in version 25
<Source>.StatDate
<Source>.StatDate
Returns the date of the last update for the index statistics.
Versions 25 and later
<Source>.State
New in version 25
<Source>.State
<Source>.State
Used to find out the state of a record.
Versions 25 and later
<Source>.StatNbDuplicates
New in version 25
<Source>.StatNbDuplicates
<Source>.StatNbDuplicates
Returns the number of duplicates for a given key item.
Versions 25 and later
<Source>.StatNbRec
New in version 25
<Source>.StatNbRec
<Source>.StatNbRec
Returns the number of entries for a given key item.
Versions 25 and later
<Source>.StatNbRecRange
New in version 25
<Source>.StatNbRecRange
<Source>.StatNbRecRange
Returns an estimate regarding the number of entries for a given key item in a given interval of values.
Versions 25 and later
<Source>.StatTime
New in version 25
<Source>.StatTime
<Source>.StatTime
Returns the time of the last update for the index statistics.
Versions 25 and later
<Source>.ToFile
New in version 25
<Source>.ToFile
<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.
Versions 25 and later
<Source>.ToItem
New in version 25
<Source>.ToItem
<Source>.ToItem
Assigns the specified value to an item of the current record.
Versions 25 and later
<Source>.TransactionFree
New in version 25
<Source>.TransactionFree
<Source>.TransactionFree
Transforms all the records "in transaction" into "Normal" records if these records do not belong to a transaction currently in progress.
Versions 25 and later
<Source>.UnlockFile
New in version 25
<Source>.UnlockFile
<Source>.UnlockFile
Unlocks the records of a data file:
Versions 25 and later
<Source>.UnlockRecNum
New in version 25
<Source>.UnlockRecNum
<Source>.UnlockRecNum
Unlocks a record that was locked by:
Versions 25 and later
<Source>.Version
New in version 25
<Source>.Version
<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.
Versions 25 and later
<Source>.ViewToFile
New in version 25
<Source>.ViewToFile
<Source>.ViewToFile
Saves the modifications performed in a HFSQL view (by <Source>.Modify, <Source>.Delete or <Source>.Cross) in the corresponding data file. This function is using the former mechanism of views.
Versions 25 and later
<Source>.Write
New in version 25
<Source>.Write
<Source>.Write
Writes a record into a data file without updating the indexes corresponding to all keys used in the file.
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment