PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • How to describe an item by programming?
  • List of HFSQL properties that can be used to describe an item by programming
  • Syntax 2: Describing a temporary item in Hyper File 5.5 format (backward compatibility)
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
HDescribeItem (Function)
In French: HDécritRubrique
ODBCNot available with this kind of connection
Describes a file item by programming.
After the call to HDescribeItem:
  • The item can be handled like any other item described in the analysis.
  • The item description cannot be modified anymore.
  • The description variable of item is re-initialized. A new item description can be performed.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
HDescribeItem(CustomerBis, CustomerName)
Syntax

Describing an item of a data file created by programming Hide the details

<Result> = HDescribeItem(<File Name> , <Item Name>)
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HErrorInfo is used to identify the error.
<File Name>: File Description variable
Name of data file in HFSQL Classic format (described by HDescribeFile).
<Item Name>: Item Description variable
Name of Item Description variable corresponding to the item to create.
WINDEVWEBDEV - Server codeReports and QueriesAjaxUser code (UMC)

Describing a temporary item in Hyper 5.5 format (backward compatibility only) Hide the details

<Result> = HDescribeItem(<Logical Name of Hyper File 5.5 File> , <Item Description> [, <Array Dimension>])
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HErrorInfo is used to identify the error.
<Logical Name of Hyper File 5.5 File>: Character string
Name of temporary data file in Hyper File 5.5 format described by HDescribeFile (Syntax 2).
<Item Description>: Character string
Description of item in the following format: <Item Name>,<Item Type> (no space between <Item Name> and <Item Type>).
<Item Name> contains the name of item
<Item Type> contains the item type and it can take one of the following values:
  • E: for the Integer items
  • M: for the Long Integer items
  • C: for the Short Integer items
  • S: for the Simple Real items
  • D: for the Double Real items
  • A: for the Date items on 8 digits (YYYYMMDD)
  • H: for the Time items (HHMM)
  • T,<Size>: for the Text items (<Size> is the size of character string)
  • M: for the Text Memo items
  • O: for the Binary Memo items
  • F: for the Currency items
<Array Dimension>: Optional integer
Size of array of items.
Remarks

How to describe an item by programming?

To describe an item by programming, you must:
  1. Use the File Description, Item Description and Link Description variables (if necessary).
  2. Describe the characteristics of data file, items and links via the HFSQL properties.
  3. Define the description of items with HDescribeItem.
  4. Define the description of data file (HDescribeFile) and links (HDescribeLink).

List of HFSQL properties that can be used to describe an item by programming

The following properties are available in read/write.
AccentuationSensitive..AccentuationSensitive is used to configure the management mode of accented characters in the different searches performed on the item or on the full-text index (by HReadSeek, HReadSeekFirst and HReadSeekLast for example).
CaseSensitive..CaseSensitive is used to configure the management mode of case (uppercase/lowercase characters) in the different searches performed on the item or on the full-text index (by HReadSeek, HReadSeekFirst and HReadSeekLast for example).
Component..Component is used to configure the different components of a composite key.
DefaultValue..DefaultValue is used to:
  • Find out the default value of an item. This item was defined in the data model editor or by programming.
  • Define the default value of an item (when describing the item by programming).
KeyExpression..KeyExpression is used to configure the different components of a composite key.
KeyType..KeyType is used to configure the characteristics of a key item.
Name..Name is used to find out:
  • the name of the font associated with a Font variable.
  • the name of a control, report or report block.
  • the name of a control, group of controls or window.
  • the name of a control, group of controls or page.
NbArrayElement..NbArrayElement is used to configure the number of elements in an array item.
PunctuationSensitive..PunctuationSensitive is used to configure the management mode of punctuation (comma, dot, etc.) in the different searches performed on the item or on the full-text index (by HReadSeek, HReadSeekFirst and HReadSeekLast for example).
Size..Size is used to find out and modify the size of an element.
SortType..SortType is used to:
  • Find out the sort direction defined for an item or for a component of a composite key. This item was defined in the data model editor or by programming.
  • Define the sort direction for an item or for a component of a composite key (when describing the item by programming).
Type..Type is used to find out:
  • the type of element described by programming (file or item description) or not (file or item defined in the data model editor, view or query).
  • the type of object.
  • the type of value stored in a variant.
WINDEVWEBDEV - Server codeAjaxHyper File 5.5

Syntax 2: Describing a temporary item in Hyper File 5.5 format (backward compatibility)

This syntax is used to create temporary items in the temporary data files in Hyper File 5.5 format. This syntax can only be used in an application developed with WINDEV 5.5 or WEBDEV 1.5 then migrated to version 18. To use this function:
  • the analysis in WINDEV 5.5 format must be accessible on the development computer.
  • the path of the WINDEV 5.5 analysis must be specified in the characteristics of the analysis ("Details" tab).
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Linux wd230hf.so
Windows Mobile wp230hf.dll
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment