|
|
|
|
|
|
|
|
|
|
- Using space characters in the parameters
- Describing an item
- Limitations
HDBDescribeField (Function) In french: HDBDécritRubrique
  Available only with these kinds of connection
Describes through programming each item found in the structure of an xBase file described by HDBDescribeFile. Note: the files described in the programming section are in dBase3 format. HDBDescribeFile("CLIENT", "DA", "C:\FIC\CLIENT.DBF")
HDBDescribeField("NOM,C,20")
HDBDescribeField("PRENOM,C,20")
HDBDescribeField("MARIE,L")
HDBDescribeField("DATNAISS,D")
HDBDescribeField("INFOS,M")
HDBDescribeIndex("C:\FIC\FICNOM.NDX", "NOM")
HDBDescribeIndex("C:\FIC\FICNP.NDX", "NOMPRE,C,40", "NOM+PRENOM")
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:
where: - <Nom de la rubrique> Name which will then be used to manipulate this item directly by programming.
- <Type de la rubrique> Type of item to be created:
| | | 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. | | M | Boolean item | | D | Date item (in "YYMMDD" format) | | M | Text 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("PRENOM, C, 20")
You must write: HDBDescribeField("PRENOM,C,20")
- 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.
This function is not available when using a stand-alone executable.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|