ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Hyper File functions available for backward compatibility
The following are the Hyper File functions (used in version 5.5) kept for compatibility and the equivalent functions in version 2025.
BinaryInfoUsed to get information on 4.1 binary memo (type, name, date, time and size of the source file).

Equivalent function: HInfoMemo
BinaryLoadLoads a binary file in a 4.1 memo item (initialize a binary memo with the file content).

Equivalent function: HLinkMemo.
BinarySaveSaves the content of a 4.1 binary memo item in a file.

Equivalent function: HExtractMemo
HAlias_55Creates an alias for a logical file or cancels all existing aliases of a logical file.

Equivalent function: HAlias.
HAliasExternalLoads the description of Hyper File files contained in an analysis external to the application without closing the current analysis.

Equivalent functions:
  • HDeclare: Imports a file description from an analysis other than the current analysis.
  • HDeclareExternal: Imports a file description from an existing file.
HAssignModifies the access path to a file.

Equivalent function: HChangeDir.
HCopyRecord_55Copies the current record in a file to the current record of another file with the same structure.

Equivalent function: HCopyRecord
HCreateView_55Creates a view on a Hyper File file.

Equivalent function: HCreateView.
HDescribeKeyDescribes a simple or composite key in a temporary file in Hyper File format.

Equivalent method:
  1. Declare a variable of type Item Description.
  2. Define all the properties of the item with the HFSQL properties.
  3. Use HDescribeItem to validate the item creation.
HDescribeTrigger_55Adds or modifies a trigger on Hyper File.

Equivalent function: HDescribeTrigger
HDuplicatesChecks the uniqueness of a key.

Equivalent operation: this function has been replaced by:
  • an automatic management of duplicates, allowing the user to enter a different value for the item generating a duplicate error.
  • the HErrorDuplicates function.
HEndLockMarks the end of file locking: all locked records are unlocked.

Equivalent functions:
HImportText_55Imports a text file into a Hyper File file.

Equivalent function: HImportText.
HIndex_55Reindexes a Hyper File file belonging to the current analysis.

Equivalent function: HIndex.
HInfoGeneReturns general information about a Hyper File file.

Equivalent operation: this function has been replaced by:
  • functions (for example, HNbRec replaces the H.NbRec variable).
  • HFSQL properties (for example, the Directory property replaces the H.Dir variable).
HInfoItemUsed to get information about an analysis item.

Equivalent operation: this function has been replaced by various HFSQL properties.
HIsLockedChecks whether the last WINDEV operation was run or not.

Equivalent operation: this function has been replaced by:
  • an automatic management of locks (that can be disabled if necessary),
  • the HErrorLock function.
HReadFirstLockReads and locks the first record of the file according to the specified key.

Equivalent function: HReadFirst with constants for blocking management.
HReadFirstNoLockReads the first record according to the specified key. If the file is locked, the record read is not locked.

Equivalent function: HReadFirst with constants for blocking management.
HReadLastLockReads and locks the last record of the file according to the key passed as parameter.

Equivalent function: HReadLast with constants for blocking management.
HReadLastNoLockReads the last file record according to the key passed as parameter. If the file is locked, the record read is not locked.

Equivalent function: HReadLast with constants for blocking management.
HReadLockReads and locks a record according to the specified record number.

Equivalent function: HRead with constants for blocking management.
HReadNextLockReads and locks the previous record according to the specified key.

Equivalent function: HReadNext with constants for blocking management.
HReadNextNoLockReads the next record according to the specified key. If the file is locked, the record read is not locked.

Equivalent function: HReadNext with constants for blocking management.
HReadNoLockReads the record according to the specified record number. If the file is locked, the record read is not locked.

Equivalent function: HRead with constants for blocking management.
HReadPreviousLockReads and locks the previous record according to the specified key.

Equivalent function: HReadPrevious with constants for blocking management.
HReadPreviousNoLockReads the previous record according to the specified key. If the file is locked, the record read is not locked.

Equivalent function: HReadPrevious with constants for blocking management.
HReadSeekLockReads and locks the first record which value of the specified key is equal to or greater than the value of the search criterion.

Equivalent function: HReadSeek with constants for blocking management.

Equivalent function: HReadSeek with constants for blocking management.
HReadSeekNoLockReads the first record which value of the specified key is equal to or greater than the value of the search criterion. If the file is locked, the record read is not locked.

Equivalent function: HReadSeek with constants for blocking management.
HStartLockMarks the beginning of the read lock on files. All the 'simple' read functions automatically lock the records that have been read.

Equivalent functions:
HSubstNameModifies the physical name of a data file.

Equivalent function: HChangeName.
HViewToTablePopulates a Table control programmatically with a view.

Equivalent function: FileToMemoryTable.
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 11/23/2024

Send a report | Local help