AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL
  • Special cases
  • Handling records during a transaction
  • Transactions and independent HFSQL context
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
Transforms all the records "in transaction" into "normal" records if these records do not belong to a transaction currently in progress. If a record in the specified data file is considered to be in a transaction, but does not belong to any current transaction, it is automatically freed.
Caution: this is an advanced function. Use this feature when it is not possible to roll back incomplete transactions (e.g. files deleted from a transaction).
Ejemplo
// Frees all the records in transaction that may be used
Customer.TransactionFree()
Sintaxis

Liberar un archivo de datos Ocultar los detalles

<Result> = <Source>.TransactionFree()
<Result>: Booleano
  • True if the operation is performed,
  • False if a problem occurs. HErrorInfo returns more details about the error.
<Source>: Tipo de fuente especificada
Name of the HFSQL Classic or Client/Server data file for which the records in transaction must be freed.
AndroidWidget Android iPhone/iPadIOS WidgetMac Catalyst Only the HFSQL Client/Server data files can be used.

Liberar un registro de un archivo de datos Ocultar los detalles

<Result> = <Source>.TransactionFree(<Record number>)
<Result>: Booleano
  • True if the operation is performed,
  • False if a problem occurs. HErrorInfo returns more details about the error.
<Source>: Tipo de fuente especificada
Name of the HFSQL Classic or HFSQL Client/Server data file for which the record in transaction must be freed.
AndroidWidget Android iPhone/iPadIOS WidgetMac Catalyst Only the HFSQL Client/Server data files can be used.
<Record number>: Entero
Number of the record to be removed.
If this parameter set to 0 or to the hCurrentRecNum constant, <Source>.TransactionFree will read the current record.
Observaciones

Special cases

  • This function can only be used for the data files in HFSQL format. For all the other types of data files, this function has no effect and it returns True.
  • The records that cannot be read (locked records for example) are ignored.
  • AndroidWidget Android iPhone/iPadIOS WidgetMac Catalyst The management of transactions is available for HFSQL Client/Server databases.
  • This function can be used to free the transactions performed on data files in an HFSQL cluster.

Handling records during a transaction

During a transaction, some rules must be complied with when handling the records. For more details, see Transactions: Handling the records during a transaction.

Transactions and independent HFSQL context

When copying a context, if a transaction is in progress on the first context, the new context is not in transaction. You must call <variable Connection>.TransactionStart (or <Variable Connection>.Transaction) to start a transaction in the new context.
Componente: wd300hf.dll
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: 22/11/2024

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