PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
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
..SynchroHFSQL is used to:
  • find out the refresh mode of a browsing Table control linked to a HFSQL Client/Server data file.
  • specify the refresh mode of a browsing Table control linked to a HFSQL Client/Server data file.
Remark: This property is equivalent to the option "Synchronize the display" found in the "Content" tab of the description window of Table control:
Synchronizing the display
Example
// Defines the refresh mode of Table control
TABLE_Customer..SynchroHFSQL = syncModification
// Modify the HFSQL Client/Server file linked to the control
CUSTOMER.ZC = 34980
HModify(CUSTOMER)
// The Table control will be automatically refreshed if this customer is visible in the control
Syntax

Finding out the refresh mode of a browsing Table control linked to a HFSQL Client/Server data file. Hide the details

<Result> = <Browsing Table control>..SynchroHFSQL
<Result>: Integer constant
Current refresh mode:
syncAdditionSynchronization when adding a record into the data file.
syncNoneNo synchronization is performed.
syncModificationSynchronization when modifying a record in the data file
syncDeletionSynchronization when deleting a record from the data file
<Browsing Table control>: Character string (with or without quotes)
Name of browsing Table control to use.

Modifying the refresh mode of a browsing Table control linked to a HFSQL data file Hide the details

<Browsing Table control>..SynchroHFSQL = <New mode>
<Browsing Table control>: Character string (with or without quotes)
Name of browsing Table control to use.
<New mode>: Integer constant (or combination of constants)
New refresh mode:
syncAdditionSynchronization when adding a record into the data file.
syncNoneNo synchronization is performed.
syncModificationSynchronization when modifying a record in the data file
Caution: Only the rows displayed by the Table control (which means the visible rows) can be automatically modified when modifying the linked HFSQL file.
syncDeletionSynchronization when deleting a record from the data file

Remark: The syncAddition, syncModification and syncDeletion constants can be combined.
Caution: Increasing the number of supported cases increases the server load.
Remarks
  • This property is ignored for:
    • the browsing tables linked to a HFSQL Classic file,
    • the browsing tables that handle files via a Native Connector (also called Native Access),
    • the memory tables, ...
  • Caution: Enabling this feature increases the server load when displaying the Table control or when moving in the control.
  • The modifications performed in the data file can come from the same application, from another application on the same computer or from another application on another computer.
See also
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment