PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

X
Y
New WINDEV 23 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
..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.
Note: 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

Note: 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.
Minimum required version
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment