ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage properties / HFSQL properties
  • Special case: View and query
  • Error cases
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
NullSupported (Property)
In french: NullSupporté
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
The NullSupported property is used to manage the NULL value in HFSQL data files.
This property is used to:
  • Determine how the NULL value is handled for a data file described in the data model editor.
  • Define that the NULL value will be handled when a data file is defined programmatically.
Remark: If a data file supports the NULL value and if the field allows NULL (property NullAllowed), it will be possible to use property Null to, for example, assign NULL to the field for the current record.
Example
// Définir la gestion de la valeur NULL dans le fichier de données Client
Client.NullSupporté = True
Syntax

Determining if the data supports the NULL value Hide the details

<Result> = <Data file>.NullSupported
<Result>: Boolean
  • True if the file supports the NULL value,
  • False otherwise.
<Data file>: Character string
Logical name of the data file used. This name is defined in the data model editor or with the File Description type.
WINDEVWEBDEV - Server codeReports and QueriesiPhone/iPadIOS WidgetUser code (UMC)Ajax

Defining how the NULL value will be handled Hide the details

<Data file>.NullSupported = <Management mode>
<Data file>: Character string
Logical name of the data file used. This name is defined with the File Description type.
<Management mode>: Boolean
  • True to manage the NULL value,
  • False otherwise.
Remarks

Special case: View and query

When used on a view or query, the NullSupported property returns True if at least one of the source files supports the NULL value.

Error cases

Write access to the Null property fails if the NullSupported property is set to False.
The error 70409 ("You have called HModify. The <XXXX> file does not support the access to the Null property. The management of the Null value must be enabled in the file description.") occurs if the following conditions are fullfilled:
  • an item found in a query or in a view is set to NULL,
  • this item comes from a file that does not support the NULL value
  • HModify is used on the query or on the view.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/20/2024

Send a report | Local help