Skip to content

DF_HIGH_DATA_INTEGRITY

See Also: Get_Attribute, Set_Attribute, DF_FILE_INTEGRITY_CHECK

Sets or disables high data-integrity mode for tables.

Level

Global

Type

Boolean, temporary

Access

Read / Write

Values

  • True
  • False

Remarks

If DF_HIGH_DATA_INTEGRITY is True, all disk writes (save, delete, etc.) are immediately followed by a low-level file close. This forces the O/S to write the table’s buffers to disk and to update the table's folder entry. While this offers some protection from power failures and system crashes, it also degrades performance.

This setting only applies to Embedded Database tables.

The attribute is set to False by default. When this attribute is set, it is usually set once at the beginning of a program.

Procedure ShowHighIntegrity
    Boolean bIntegrity
    Get_Attribute DF_HIGH_DATA_INTEGRITY To bIntegrity
    Showln "High data integrity is " (If(bIntegrity, "ON", "OFF"))
End_Procedure

The sample procedure above shows the current setting of the attribute.

Notes

Caution: Enabling DF_HIGH_DATA_INTEGRITY is no substitute for properly disabling opportunistic locking on Windows networks when using the embedded database.

See the Data Access Worldwide white paper titled "Opportunistic Locking and Read Caching on Microsoft Windows Networks" that tells you how to properly configure Windows Networks for use with the embedded (DataFlex) database. This white paper is available from the white papers section of the Data Access Worldwide website.