Home | Sign in | English EN

  • Closing data files
  • Example for handling the data files installed locally and remotely
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
<Source>.SetRemoteAccess (Function)
In french: <Source>.GèreAccèsDistant
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
Temporarily disables the remote access in order to access HFSQL Classic data files found locally. By default, the remote access is automatically managed as soon as a remote analysis is opened by HOpenAnalysis.
Caution: The use of this function is reserved to experienced developers. <Source>.SetRemoteAccess applies to HFSQL data files only. Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Customer.SetRemoteAccess(True) // The following HFSQL commands will be performed remotely
Customer.Open() // Open a remote file
Orders.SetRemoteAccess(False) // The Orders data file becomes local
Customer.ReadFirst() // Read the first record remotely
Orders.ReadFirst() // Read the first record locally
<Former mode> = <Source>.SetRemoteAccess(<Management mode>)
<Former mode>: Boolean
  • True if remote access was supported before the call to <Source>.SetRemoteAccess,
  • False if remote access was not supported before using <Source>.SetRemoteAccess.
<Source>: Type corresponding to the specified source
Name of the data file used. Used to enable (or not) the management of remote access for a single data file.
<Management mode>: Boolean
  • False to temporarily disable the management of remote access,
  • True to re-enable the management of remote access.

Closing data files

Temporarily disabling the management of remote access does not close the data files used locally or remotely.

Example for handling the data files installed locally and remotely

  • Opening a remote analysis with HOpenAnalysis. The management of the remote access is enabled.
  • Opening the remote RPCFile data file with <Source>.Open.
  • Looping through the RPCFile remote data file.
  • Temporarily disabling remote access with <Source>.SetRemoteAccess.
  • Opening the local LocalFile data file with <Source>.Open.
  • Looping through the LocalFile local data file.
  • Re-enabling remote access with <Source>.SetRemoteAccess.
  • The following data files are accessible:
    • Local LocalFile file,
    • Remote RPCFile file.
Component: wd270hf.dll
Minimum version required
  • Version 25
This page is also available for…
Click [Add] to post a comment