ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Attention : This is version 27 of this documentation page. This feature may have been changed or removed in a higher version.
Help / WLanguage / Managing databases / HFSQL functions / HFSQL functions / Prefix syntax
  • Closing data files
  • Example for handling the data files installed locally and remotely
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
<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.
Example
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
Syntax
<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.
Remarks

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…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help