ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Miscellaneous
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
Declares a description of data file (found in an analysis) in the current project. This import is temporary and it can be canceled by HCancelDeclaration.
// Declare a SupplierWD data file from the SALESMGT analysis
HDeclare("Supplier", "\Examples\SalesMgt\SALESMGT.WDD", "", "SupplierWD")
Syntax
<Result> = HDeclare(<Data file> , <Full path of the WDD file> [, <WDD password> [, <Alias> [, <Options>]]])
<Result>: : Boolean
  • True if the operation was performed,
  • False if a problem occurs. HError is used to identify the error.
<Data file>: Character string
Logical name of the data file to import, used in the external analysis.
<Full path of the WDD file>: Character string
Full access path to the analysis file (.WDD file) containing the description of the HFSQL data file to import (up to 260 characters).
This file can correspond to a WDD file created by an earlier version of WINDEV or WEBDEV.
<WDD password>: Optional character string
  • Password associated with the analysis.
  • Empty string ("") if no password is used.
<Alias>: Optional character string
Logical name of the data file, used to handle the data file. By default, this name corresponds to <Data file>.
This parameter is necessary if the current analysis already contains a data file whose logical name is <Data file>, or if a <Data file> has been described by HDeclareExternal or HDescribeFile.Logical name of the data file, used to handle the data file. By default, this name corresponds <Source>.
This parameter is necessary if the current analysis already contains a data file whose logical name is <Source>, or if a <Source> has been described by HDeclareExternal or HDescribeFile.
<Options>: Optional integer constant
Search options:
hDisk
(Default value)
The <Full path of WDD> analysis is sought on the disk (most common case).
hWDLThe <Full path of WDD> analysis is sought according to the following priorities:
  1. In the main library (.WDL file)
  2. In the different libraries according to the load order, then on disk.
  3. In the main library of the component.
  4. In the secondary libraries of the component according to the load order.
Remarks

Miscellaneous

  • There is no need to have an analysis linked to the current application to import a description of data file.
  • All the HFSQL functions can be used on the imported data file except for the integrity management.
  • You can import as many descriptions as necessary.
  • This function allows you to use data files described in the earlier WINDEV and WEBDEV analyses (WINDEV 4.1 to 5.5, WEBDEV 1.0 and 1.5).
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/04/2024

Send a report | Local help