<Source>.Flush (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

.Security and <Source>.Flush

ErrorStatusModification

FilterIncludedBetween

MigrateLinkedCompositeKey

Managing locks
.Security and <Source>.Flush

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Source>.Flush (Function)

In french: <Source>.ForceEcriture

Available only with these kinds of connection

Forces the operating system of the computer where the data files are found to write data onto the disk. The HFSQL context of the data file used is stored (lock, current browse, ...).

Remark: Used on a regular basis, this function minimizes the loss of data caused by the unexpected system outage on the computer where the data files are located (power failure for example).

Versions 16 and later

This function is now available for Java applications.

This function is available for HFSQL data files only. It is not available for the data files accessed by JDBC.

New in version 16

This function is now available for Java applications.

This function is available for HFSQL data files only. It is not available for the data files accessed by JDBC.

This function is now available for Java applications.

This function is available for HFSQL data files only. It is not available for the data files accessed by JDBC.

Versions 18 and later

This function is now available in Android Widget mode.

This function is now available for Android applications (for HFSQL data files).

This function is now available in Windows Store apps mode.

This function is now available for iPhone/iPad applications.

New in version 18

This function is now available in Android Widget mode.

This function is now available for Android applications (for HFSQL data files).

This function is now available in Windows Store apps mode.

This function is now available for iPhone/iPad applications.

This function is now available in Android Widget mode.

This function is now available for Android applications (for HFSQL data files).

This function is now available in Windows Store apps mode.

This function is now available for iPhone/iPad applications.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Example

// Add a record in a data file
// (record described by programming)
Customer.LastName = "Clark"
Customer.FirstName = "Vince"
Customer.Address = "Palm lane"
Customer.City = "San Francisco"
Customer.Zip = "94102"
Customer.Country = "USA"
Customer.Add()
// Forces a write operation into Customer file
Customer.Flush()

Syntax

<Source>.Flush()

<Source>: Type corresponding to the specified source

Name of data file used.

Remarks

Managing locks

During the call to <Source>.Flush, the data file used is closed and re-opened. If locks were implemented on this data file before it was closed, these locks are automatically restored when it is re-opened. Indeed, when closing a data file, the operating system deletes the locks implemented on this data file.

Remark: It is not advisable to call this function too often on:

data files on which an important number of locks is implemented.
data files on which an important number of write operations is implemented.

<Source>.Security and <Source>.Flush

<Source>.Security and <Source>.Flush can both be used to force a physical write operation on disk.

However:

<Source>.Security is used to force a write operation into the data files used during each write operation. This write operation is automatically performed by the HFSQL engine. The data files used are not closed during this write operation. The speed of the write-to-file operation is slower.
<Source>.Flush is used to force a write operation into the data files used during the call to this function. The data files used are closed then re-opened during this write operation. The speed of the write-to-file operation is not slowed down.

Component: wd260hf.dll