ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / Properties associated with windows, pages and controls
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
The SynchroHFSQL property is used to:
  • get the refresh mode of a Table control based on a data file linked to an HFSQL Client/Server data file.
  • specify the refresh mode of a Table control based on a data file linked to an 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

Getting the refresh mode of a Table control based on a data file linked to an HFSQL Client/Server data file Hide the details

<Result> = <Table control based on a data file>.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
<Table control based on a data file>: Control name
Name of the Table control based on a data file to be used.

Changing the refresh mode of a Table control linked to an HFSQL Client/Server data file Hide the details

<Table control based on a data file>.SynchroHFSQL = <New mode>
<Table control based on a data file>: Control name
Name of the Table control based on a data file to be used.
<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:
    • Table controls linked to an HFSQL Classic data file,
    • Table controls that handle data files via a Native Connector (also called Native Access),
    • Table controls populated programmatically, etc.
  • Caution: Enabling this feature increases the server load when displaying the Table control or when elements are moved within 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.
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/04/2024

Send a report | Local help