ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / Managing xBase files / WLanguage functions
  • Using space characters in the parameters
  • Describing an item
  • Limitations
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
HDBDescribeField (Function)
In french: HDBDécritRubrique
Native Connectors (Native Accesses)HFSQL ClassicAvailable only with these kinds of connection
Describes through programming each item found in the structure of an xBase file described by HDBDescribeFile.
Remark: the files described by programming are files in dBase3 format.
Example
HDBDescribeFile("CUSTOMER", "DA", "C:\FILE\CUSTOMER.DBF")
HDBDescribeField("LASTNAME,C,20")
HDBDescribeField("FIRSTNAME,C,20")
HDBDescribeField("MARRIED,L")
HDBDescribeField("DOB,D")
HDBDescribeField("INFO,M")
HDBDescribeIndex("C:\FILE\LASTNFILE.NDX", "LASTNAME")
HDBDescribeIndex("C:\FILE\LNFNFILE.NDX", "FULLNAME,C,40", "LASTNAME+FIRSTNAME")
HDBCreation()
Syntax
<Result> = HDBDescribeField(<Name and type of item>)
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurs. HError is used to identify the error.
<Name and type of item>: Character string
Name given to the item and type of item. This parameter has the following format:
<Item name>, <Item type>
where:
  • <Item name>: Name that will be used to handle this item by programming.
  • <Item type>: Type of item to create:
    C,<Size>Text item, <Size> is the size of character string
    N,<Size>,<NbDecimals>Numeric item. <Size> is the size of numeric value, <NbDecimals> is the number of decimals in the numeric value.
    MBoolean item
    DDate item (in "YYMMDD" format)
    MText Memo item
Remarks

Using space characters in the parameters

The parameters must not be separated by space characters; for example, you must not write:
HDBDescribeField("FIRSTNAME, C, 20")
You must write:
HDBDescribeField("FIRSTNAME,C,20")

Describing an item

  • An error 1009 will be generated if the file is already opened during the call to HDBDescribeField.
  • The keys (or indexes) are defined by HDBDescribeIndex.
  • The number of items created in a file by HDBDescribeField cannot exceed 128.
  • The maximum size of an item:
    • cannot exceed 254 characters for a non-key text item.
    • cannot exceed 100 characters for a key text item.
    • cannot exceed 19 digits in the integer part and 15 digits in the decimal part for a numeric item.
  • To use HDBDescribeField, the file was described by HDBDescribeFile.

Limitations

  • This function is not available when using a database via Remote Access.
  • This function is not available when using a stand-alone executable.
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help