PC SOFT

AYUDA EN LÍNEA
DE WINDEV, WEBDEV Y WINDEV MOBILE


WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Otros
Procedimientos almacenados
NullIfEmpty (Property)
 
..NullIfEmpty is used to:
  • Find out whether the value returned by the control is NULL if its content is empty.
  • Configure the value returned by the control if its content is empty.
Note: This property is equivalent to the "Return NULL if empty" option found in the description window of control ("Details" tab).
Ejemplo
EDT_MinPrice..NullIfEmpty = True
EDT_MaxPrice..NullIfEmpty = True
REQ_Find.ParamMinPrice = EDT_MinPrice
REQ_Find.ParamMaxPrice = EDT_MaxPrice
HExecuteQuery(QRY_Find)
Sintaxis

Finding out whether the value returned by the control is NULL if its content is empty Ocultar los detalles

<Result> = <Control Name>..NullIfEmpty
<Result>: Boolean
  • True if the value returned by the control is NULL if its content is empty,
  • False otherwise.
<Control Name>: Character string (with or without quotes)
Name of control to use. This control can correspond to an edit control or to an editable Combo Box control.

Configuring the value returned by the control if its content is empty. Ocultar los detalles

<Control Name>..NullIfEmpty = <New Management Mode>
<Control Name>: Character string (with or without quotes)
Name of control to use. This control can correspond to an edit control or to an editable Combo Box control.
<New Management Mode>: Boolean
  • True if the value returned by the control is NULL if its content is empty,
  • False otherwise.
Observaciones
  • this property allows you to easily perform multicriteria searches via a query with parameters in which the values of parameters correspond to edit controls. Indeed, the query parameters whose value is NULL are ignored. See Using a query with parameters for more details.
  • This property has no effect when assigning a value to the control.
  • This property is available for the edit controls and for the editable Combo Box controls.
Versión mínima requerida
  • Versión 19
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario