SynchroHFSQL (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / WLanguage properties / Properties associated with windows, pages and controls

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SynchroHFSQL (Property)

In french: SynchroHFSQL

The SynchroHFSQL property is used to:

know how to refresh a Table control linked to an HFSQL Client/Server data file.
specify the refresh mode of a Table control bound to an HFSQL Client/Server data file.

Note: This property is equivalent to the "Synchronize display" option in the "Contents" tab of the Table control description window:

Example

// Définit le mode de rafraîchissement du champ Table
TABLE_Client.SynchroHFSQL = syncModification
// Modification du fichier de données HFSQL Client/Serveur lié au champ
CLIENT.CP = 34980
HModify(CLIENT) 
// Le champ Table sera automatiquement mis à jour si ce client est visible dans le champ

Syntax

Learn how to refresh a Table control linked to an HFSQL Client/Server data file Hide the details

<Result> = <Table control>.SynchroHFSQL

<Result>: Integer constant

Current refresh mode:
syncAddition Synchronization when adding a record into the data file.
syncNone No synchronization is performed.
syncModification Synchronization when modifying a record in the data file
syncDeletion Synchronization when deleting a record from the data file

<Table control>: Control name

Name of the Table control to be used. This field is linked to a data file.

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

<Table control>.SynchroHFSQL = <New mode>

<Table control>: Control name

Name of the Table control to be used. This field is linked to a data file.

<New mode>: Integer constant (or combination of constants)

New refresh mode:
syncAddition Synchronization when adding a record into the data file.
syncNone No synchronization is performed.
syncModification Synchronization when modifying a record in the data file
Please note: Only lines displayed by the Table control (i.e. visible) can be modified automatically when editing the linked HFSQL data file.
syncDeletion Synchronization when deleting a record from the data file

Note: It is possible to combine the constants syncAdd, syncModification constants and syncDelete constants.
Please note: As the number of cases managed increases, so does the server load..

Remarks

This property is ignored for:
- Table fields linked to an HFSQL Classic data file,
- Table fields manipulating data files via a Native Access connector,
- table populated programmatically, etc.
Caution: Enabling this feature increases server load when displaying the Table control or when moving within the field.
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.