AYUDA EN LÍNEA
 WINDEV, WEBDEV Y WINDEV MOBILE
Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL
  • Managing locks
  • .Security and <Source>.Flush
WINDEV
WindowsLinuxJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadIOS WidgetApple WatchMac Catalyst
Otros
Procedimientos almacenados
<Source>.Flush (Función)
HFSQL ClassicHFSQL Client/ServerDisponible solo con estos tipos de conexión
Forces the operating system of the computer where the data files are found to write data onto the disk. The HFSQL context of the manipulated data file is preserved (blocking, current path, etc.).
Note If used regularly, this function minimizes data loss caused by unexpected shutdowns of the workstation on which the data files are stored (e.g. power cuts).
Java This function is available for HFSQL data files only. It is not available for the data files accessed by JDBC.
Ejemplo
// Add a record in a data file
// (record described through 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()
Sintaxis
<Source>.Flush()
<Source>: Tipo de fuente especificada
Name of the data file used.
Observaciones
WINDEVWEBDEV - Código ServidorReportes y ConsultasiPhone/iPadCódigo de Usuario (UMC)AjaxHFSQL ClassicHFSQL Client/Server

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: We therefore advise against calling 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. The HFSQL engine automatically performs the write operation. The data files are not closed during this write operation. This results in slower write speeds.
  • <Source>.Flush forces the data file(s) to be written when it is called. The data files are closed and then re-opened during this write operation. The write operation is not slowed down.
Componente: wd300hf.dll
Ver también
Versión mínima requerida
  • Versión 25
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 04/12/2024

Señalar un error o enviar una sugerencia | Ayuda local