AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Este contenido se ha traducido automáticamente.  Haga clic aquí  para ver la versión en inglés.
Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL
  • Conditions for using <Source>.CancelDeclaration
  • <Source>.CancelDeclaration and closing the data file
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
Allows you to:
Ejemplo
// The Customer data file was declared beforehand in the analysis 
// by HDeclareExternal
Customer.Close()
Customer.CancelDeclaration()
Sintaxis
<Result> = <Source>.CancelDeclaration()
<Result>: booleano
  • True if the operation was performed,
  • False if a problem occurs. HError is used to identify the error.
<Source>: Tipo de fuente especificada
Corresponds to:
  • the name of data file (defined in the analysis). If this name is not specified, <Source>.CancelDeclaration handles the last data file used.
  • the name of query or data source associated with a query (when freeing resources once <Source>.ExecuteQuery or <Source>.ExecuteSQLQuery has been used).
Observaciones

Conditions for using <Source>.CancelDeclaration

This function must be used ONLY when the relevant data file (or query) is not used anymore!
In the following example, the <Source>.CancelDeclaration function is used too early: the contents of the Table control will be completely distorted.. The Table control is populated using BuildBrowsingTable in a parallel process in the background. Therefore, <Source>.CancelDeclaration will be called before the table is entirely filled, making this table unusable.
HExecuteSQLQuery("test", "select * from customer")
BuildBrowsingTable(TABLE_Table1, "test")
HCancelDeclaration("test")
Note The problem can also occur with a variable of type "data source". A "data source" variable declared locally in a process or event (button click, procedure, method, etc.) ONLY exists while this code is run. For this reason, a "warning" is displayed if you use this type of data source: "the data source will be destroyed at the end of this code".

<Source>.CancelDeclaration and closing the data file

To use <Source>.CancelDeclaration on a data file, this data file must be closed.
If a query, a subquery or a view uses the data file, <Source>.CancelDeclaration cannot be executed, even after calling <Fuente>.Close. The queries or views that are using the data file must be freed beforehand.
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: 23/11/2024

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