PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Tips
  • hCompatible: conditions for considering the structures as being incompatible
  • Limitation
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
HCheckStructure (Function)
In French: HVérifieStructure
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
Defines the mode for comparing data files. This comparison is performed when the data files are opened.
Are compared:
  • the structure of HFSQL data file described in the analysis,
  • the real structure of physical HFSQL data file.
By default, these two structures must be strictly identical in order to be able to handle the data file.
Depending on the selected mode, a WLanguage error may occur if incompatible structures are found. In this case, you must apply the automatic modification of data files.
Note: The description used by the application always corresponds to the description of physical HFSQL file.
Versions 16 and later
WINDEVJava This function is now available for the Java applications.
Java This function is available for the HFSQL data files only. It is not available for the data files accessed by JDBC.
New in version 16
WINDEVJava This function is now available for the Java applications.
Java This function is available for the HFSQL data files only. It is not available for the data files accessed by JDBC.
WINDEVJava This function is now available for the Java applications.
Java This function is available for the HFSQL data files only. It is not available for the data files accessed by JDBC.
Versions 18 and later
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications (for the HFSQL data files).
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications (for the HFSQL data files).
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications (for the HFSQL data files).
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Example
// Allows the opening of "Customer" file
// Even if the structures are different
HCheckStructure(Customer, hNoCheck)
Syntax
<Result> = HCheckStructure([<File Name>,] <Management Mode>)
<Result>: Integer constant
Former management mode of description (before the call to HCheckStructure).
<File Name>: Optional character string (with or without quotes)
Name of data file used.
If this parameter is not specified or if it corresponds to "*", the management of descriptions is taken into account for all the data files of the analysis.
<Management Mode>: Integer constant
Selected management mode:
hNoCheckNo check is performed, the analysis description may differ from the description of physical file.
hCompatible
(default value)
The structures of data files must be compatible. If one of the following operations is performed, the structures are considered as being incompatible:
  • Adding a unique key item (except an automatic identifier).
  • Switching a key with duplicates into unique key.
  • Deleting or renaming an item.
  • Changing the type of an item (except changing from text to Unicode text).
  • Reducing the size of item.
  • Reducing the integer part or the decimal part of a Numeric item.
  • An item becomes a non-key item.
  • Deleting a full-text index.
  • Adding or deleting items to/from a full-text index (however, the creation of a new full-text item is compatible).
hIdentical
(default value)
The structures must be strictly identical.
Remarks

Tips

HCheckStructure must be used:
  • before establishing the connection to avoid the calls to the server.
  • before opening the data files.

hCompatible: conditions for considering the structures as being incompatible

If one of the following differences exists between the description of data file found in the analysis and the description of the data file saved in the physical file, the structures are considered as being incompatible by the HFSQL engine: an automatic modification is required.
Structure in the analysisStructure read in the physical data filePossible consequence
- automatic identifier
or
- key with duplicates
or
- non-key item
Unique key and not automatic identifierA duplicate error may occur when adding a record.
Note: No problem will occur if only read operations are performed on the data file.
Using the "XXX" itemThe "XXX" item does not existAdding a value for an item that does not exist in the physical file.
The "XXX" item was renamed.
Different type of item
Invalid conversion when assigning the value to the item.
Value assigned to the truncated item.
Change of operating mode:
  • Exact-match search only
  • Browse performed on the record number
Different size of item
Key itemNon-key item

Limitation

This function is not available when accessing a database via Remote Access.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment