PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Starting an application associated with an analysis
  • Starting an application not associated with an analysis
  • Opening an analysis this is already opened
  • Syntax 2: opening a remote analysis
  • Version of the analyses opened by HOpenAnalysis
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
HOpenAnalysis (Function)
In French: HOuvreAnalyse
ODBCNot available with this kind of connection
Opens an analysis in HFSQL Classic format. This allows you to access the data files described in the analysis as well as the structure of these data files.
Reminder: A single analysis can be opened at a given time. If an analysis was already opened before the call to the function, this analysis is automatically closed as well as the associated data files.
Caution: When using HOpenAnalysis, the current HFSQL context is automatically re-initialized. The following operations are automatically performed:
  • All the opened data files are closed.
  • All the existing HFSQL views are deleted.
  • All the existing queries are deleted.
  • All the declarations performed by HDeclareExternal and HDescribeFile are deleted.
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.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
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.
Example
// Open the SALESMGT analysis
HOpenAnalysis("C:\SALESMGT\SALESMGT.WDD", "Password")
Syntax

Opening a HFSQL analysis locally Hide the details

<Result> = HOpenAnalysis(<Path of .WDD> [, <Password>])
<Result>: Boolean
  • True if the analysis was opened,
  • False otherwise. HError returns more details about the problem.
<Path of .WDD>: Character string (with quotes)
Full path of ".WDD" file of analysis. This file contains the description of analysis to open.
WINDEVWEBDEV - Server code If only the drive and the name of the analysis are specified, the analysis is sought in the current directory of the specified drive.
If neither the drive, nor the analysis path are specified, the analysis is sought in the current directory of the current disk.
To find the analysis in the current directory of the specified drive, use the following syntax: <Unit>:<Analysis Name>.
<Password>: Optional character string
  • Analysis password, defined in the data model editor.
  • Empty string ("") if no password is associated with the analysis.

Opening a remote HFSQL analysis Hide the details

<Result> = HOpenAnalysis(<Path of .WDD> , <Password> , <Server Address> , <User Name> , <User Password>)
<Result>: Boolean
  • True if the analysis was opened,
  • False otherwise. HError returns more details about the problem.
<Path of .WDD>: Character string (with quotes)
Full path of ".WDD" file of analysis. This file contains the description of analysis to open.
WINDEVWEBDEV - Server code If only the drive and the name of the analysis are specified, the analysis is sought in the current directory of the specified drive.
If neither the drive, nor the analysis path are specified, the analysis is sought in the current directory of the current disk.
The following syntax <Unit>:<Analysis Name> is used to search for the analysis in the current directory of the specified drive.
<Password>: Character string (with quotes)
  • Analysis password, defined in the data model editor.
  • Empty string ("") if no password is associated with the analysis.
<Server Address>: Character string (with quotes)
IP address or DNS name of server.
Reminder: An IP address is a character string containing the "Internet Protocol" address of the computer in the xxx.xxx.xxx.xxx format.
<User Name>: Character string (with quotes)
Name of user (for accessing the data).
<User Password>: Character string (with quotes)
User password (associated with the user name) .
Remarks

Starting an application associated with an analysis

  • When starting an application, the analysis associated with this application is automatically opened. The analysis is sought in the main library of the application, then in the directory of the application.
    To make sure the analysis is found, we advise you to include the analysis in the main library of the application.
  • If HOpenAnalysis is called by an application associated with an analysis, this function:
    • has no effect if the path of the specified analysis corresponds to the path of the analysis associated with the application.
    • returns False if the path of the specified analysis does not exist. In this case, the application keeps working with the current analysis.
    • opens the analysis and returns True if the specified analysis exists and if it is valid.

Starting an application not associated with an analysis

When starting an application not associated with an analysis, no analysis is automatically opened. Therefore, HOpenAnalysis must be used.
The analysis opened by HOpenAnalysis is sought:
  • first, in the main library of the application according to its full physical name.
  • then, on the current disk.

Opening an analysis this is already opened

HOpenAnalysis has no effect if the analysis opened by HOpenAnalysis is already opened.

Syntax 2: opening a remote analysis

This syntax is used to handle the data files via Internet: this operation is transparent to the user. We recommend that you use HConnectRemoteAccess.
Caution: If a "remote" analysis is opened, some HFSQL functions are not run locally anymore: these functions are sent to the DLL for managing the remote HFSQL functions via the remote access module of wdxxxcom.dll. The only change (from a programming point of view) for an application that uses the remote access is performed in the analysis opening.
Note: To open a remote analysis, a specific configuration is required for the server and for the client computer. See Remote access with HFSQL for more details.

Version of the analyses opened by HOpenAnalysis

HOpenAnalysis cannot be used to open the analyses in Hyper File 5.5 format (and earlier). Only HFSQL Classic analyses can be opened.
To use HOpenAnalysis on Hyper File 5.5 files, you must use the " ".WDD" file of a HFSQL Classic analysis containing files in Hyper File 5.5 format. In this case, the ".WDD" file of the source WINDEV 5.5 analysis must necessarily be found in the directory of the executable.
You also have the ability to use HDeclare to handle a Hyper File 5.5 file directly.
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