ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage properties / Properties associated with windows, pages and controls
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
The property NullSiVide property property allows you 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 in the control description window ("Detail" tab).
Example
SAI_PrixMin.NullSiVide = True
SAI_PrixMax.NullSiVide = True
REQ_Rech.ParamPrixMin = SAI_PrixMin
REQ_Rech.ParamPrixMax = SAI_PrixMax
HExecuteQuery(REQ_Rech)
Syntax

Find out whether the value returned by the control is NULL if its content is empty Hide the details

<Result> = <Control used>.NullIfEmpty
<Result>: Boolean
  • True if the value returned by the control is NULL if its content is empty,
  • False otherwise.
<Control used>: Control name
Name of the control to be used. This control can correspond to an edit control or to an editable Combo Box control.

Configure the value returned by the control if its content is empty. Hide the details

<Control used>.NullIfEmpty = <New mode>
<Control used>: Control name
Name of the control to be used. This control can correspond to an edit control or to an editable Combo Box control.
<New mode>: Boolean
  • True if the value returned by the control is NULL if its content is empty,
  • False otherwise.
Remarks
  • this property allows you to easily perform multi-criteria 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. For more details, see Using a query with parameters.
  • This property has no effect when assigning the field with a value.
  • This property is only available for Edit control fields and Combo Box control fields..
Minimum version required
  • Version 19
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/13/2025

Send a report | Local help