ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
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 NbItem property is used to get the total number of items (including composite keys) in a record of:
  • a data file described in the data model editor,
  • a data file described programmatically,
  • an HFSQL view,
  • a query.
Example
// Retrieve the number of items in a record of the Customer data file
ResNbItem = Customer.NbItem
Syntax
<Number of items> = <Element used>.NbItem
<Number of items>: Integer
Number of items in a record of the element used.
<Element used>: Character string
Name of the element for which you want to find out the number of items for a record
  • name of a data file described in the data model editor or programmatically,
  • name of an HFSQL view,
  • name of a query.
Remarks
  • The NbItem property is used to get the total number of items in a record.
  • The NbKeyItem property is used to get the total number of key items in a record.
  • The NbMemoItem property is used to get the total number of memo items in a record.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/17/2023

Send a report | Local help