PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Using the EXTERN keyword
  • Describing the file
  • Limitations
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
HDBDescribeFile (Function)
In French: HDBDécritFichier
Native AccessesHFSQLAvailable only with these kinds of connection
Describes a data file in dBase3 format (most common format) by programming. This function is used to specify the name, abbreviation and access path of xBase file.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example
HDBDescribeFile("DBCUSTOMER", "CD", "C:\FILE\CUSTOMER.DBF")
HDBDescribeField("LASTNAME,C,20")
HDBDescribeField("FIRSTNAME,C,20")
HDBDescribeField("AGE,N,3,0")
HDBDescribeField("BALANCE,N,10,2")
HDBDescribeField("MARRIED,L")
HDBDescribeField("DOB,D")
HDBDescribeField("INFO,M")
HDBCréation()
Syntax
<Result> = HDBDescribeFile(<Logical Name of xBase File> , <File Prefix> , <Full Name of Physical File>)
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HError is used to identify the error.
<Logical Name of xBase File>: Character string
Logical name of xBase file to create. This name will be used by all the functions that handle xBase files.
<File Prefix>: Character string
File abbreviation (2 characters).
<Full Name of Physical File>: Character string (with or without quotes)
Path where the file will be created on disk and full file name (with the extension).
Remarks

Using the EXTERN keyword

We recommend that you use the EXTERN keyword to declare a file that will be described and created, in order to avoid warnings in the code editor. For example:
EXTERN Customer
HDBDescribeFile("CUSTOMER", "DA", "C:\FILE\CUSTOMER.DBF")

Describing the file

  • An error 1009 will be generated if the file is already opened during the call to HDBDescribeFile.
  • The file will be created on disk by HDBCreation.
  • The file structure is described by HDBDescribeField. The number of items created in a file is limited to 128.
  • The indexes are described by HDBDescribeIndex.

Limitations

  • This function is not available when accessing a database via Remote Access.
  • This function is not available when using a stand-alone executable.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment