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. HSetRemoteAccess applies to the HFSQL data files only.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
// Open a remote analysis
HOpenAnalysis("REMOTEANA.WDD", "", "192.32.8.10", "MyLogin", "Password")
// Open a remote file
HOpen("MYREMOTEFILE")
// ...
HSetRemoteAccess(False) // The following HFSQL commands will be performed locally
HOpen("MYLOCALFILE") // Open a local file
// ...
HSetRemoteAccess(True) // The following HFSQL commands will be performed remotely
// ...
HCloseAnalysis()
HSetRemoteAccess(True) // The following HFSQL commands will be performed remotely
HOpen(Customer) // Open a remote file
//...
HSetRemoteAccess(Orders, False) // The Orders file becomes local
HReadFirst(Customer) // Reads the first record remotely
HReadFirst(Order) // Reads the first record locally
Syntax
HSetRemoteAccess(<Former Mode> [, <File Name>] , <Management Mode>)
<Former Mode>: Boolean
- True if the remote access was managed before the call to HSetRemoteAccess,
- False if the remote access was not managed before the call to HSetRemoteAccess.
<File Name>: Optional character string (with or without quotes)
Name of data file used. Used to enable (or not) the management of remote access for a single data file.
If this parameter is not specified or if it corresponds to "*", the management of the remote access is taken into account for all the data files found in the analysis.
<Management Mode>: Boolean
- False to temporarily disable the management of remote access,
- True to re-enable the management of remote access.
Remarks
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 HOpen.
- Browsing the remote RPCFile data file.
- Temporarily disabling the remote access with HSetRemoteAccess.
- Opening the local LocalFile data file with HOpen.
- Browsing the local LocalFile data file.
- Re-enabling the remote access with HSetRemoteAccess.
- The following data files are accessible:
- Local LocalFile file,
- Remote RPCFile file.