PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
The NullIfEmpty property 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.
Remark: This property is equivalent to the "Return NULL if empty" option found in the description window of control ("Details" tab).
Example
EDT_MinPrice.NullIfEmpty = True
EDT_MaxPrice.NullIfEmpty = True
REQ_Find.ParamMinPrice = EDT_MinPrice
REQ_Find.ParamMaxPrice = EDT_MaxPrice
HExecuteQuery(QRY_Find)
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 management 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 management 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 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. For more details, see Using a query with parameters.
  • 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.
See also
Minimum version required
  • Version 19
This page is also available for…
Comments
Click [Add] to post a comment