PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
..NbItem is used to find out the total number of items (including composite keys) in a record found in:
  • a data file described in the data model editor,
  • a data file described by programming,
  • a HFSQL view,
  • a query.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Retrieve the number of items found in a record of Customer file
ResNbItem = Customer..NbItem
Syntax
<Number of Items> = <Element name>..NbItem
<Number of Items>: Integer
Number of items found in a record of the specified object.
<Element name>: Character string (with or without quotes)
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 by programming,
  • name of a HFSQL view,
  • name of a query.
Remarks
  • ..NbItem is used to find out the total number of items in a record.
  • ..NbKeyItem is used to find out the total number of key items in a record.
  • ..NbMemoItem is used to find out 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