PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Overview
  • Configuring the server for remote access
  • Programming
  • Accessing the database
  • Using HDescribeConnection and HChangeConnection
  • HFSQL functions that can be used in remote access
  • Optimizations
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
Overview
The remote access allows you to access all types of databases.
To do so, create an analysis accessing the external database via the native accesses or via OLE DB/ODBC. This analysis will be deployed on the server.
Then, a remote access server must be configured on the server. For a mobile application, the mobile device will use the analysis found on the server via remote access.
Configuring the server for remote access
The different steps for configuring the server are as follows:
  1. Installing the "WDRemoteAccessServer" application on the server.
    • The following DLLs of WINDEV framework must be found on the server: wdxxximg, wdxxxvm, wdxxxobj, wdxxxhf, wdxxxsql, wdxxxstd, wdxxxcom, wdxxxprn, wdxxxetat, wdxxxoldb, wdxxxmat.dll, wdxxxpnt as well as the WDTool.wdk component.The following DLLs of WINDEV framework must be found on the server: wdxxxvm, wdxxxobj, wdxxxhf, wdxxxsql, wdxxxstd, wdxxxcom, wdxxxprn, wdxxxetat, wdxxxoldb, wdxxxmat.dll, wdxxxpnt as well as the WDOutil.wdk component.
    • These elements must be copied from the "Programs" directory of WINDEV to the server.
  2. Starting the "WDRemoteAccessServer" application on the server.
  3. Selecting the analysis (.wdd file) corresponding to the data accessed via the remote access in the "Analyses" tab ("Configuration" button). This selection is performed in the "WDRemoteAccessServer" application.
  4. Defining the list of users allowed to access the data via the remote access ("Users" tab of "WDRemoteAccessServer").
  5. Configuring the following elements if necessary:
    • Communication port
    • Management of encryption
    • Automatic start, ...
  6. Starting the server. When the server is started, the server for remote access is operational and the connection can be established.
Programming

Accessing the database

To access the database via the remote access, open the analysis with HOpenAnalysis. For example:
// Open the remote analysis
HOpenAnalysis("MyAnalysis.wdd", "", EDT_IPAddress, EDT_User, EDT_PWD)
The access to the data is performed by the Hxxx functions:
// Initialize the table
HReadFirst(Customer, Name)
WHILE HOut() = False
        ...
        HReadNext(Customer)
END

Using HDescribeConnection and HChangeConnection

When using the remote access, you have the ability to call HDescribeConnection and HChangeConnection. For example:
// Connection to the RPC server
HConnectRemoteAccess("192.168.1.1", "User", "UserPassword", ...
"C:\SALESMGT\SALESMGT.WDD", "SalesMgtPassword")
HDescribeConnection("MyConnection", "", "", " Server_SQLServer ", "dbo", ...
hNativeAccessSQLServer, hOReadWrite, "")
HChangeConnection("*", "192.168.1.1")

HFSQL functions that can be used in remote access

The HFSQL functions can be used when accessing a database via remote access.
The following functions are not available for the remote access:
Versions 09 and later
HCheckStructure
New in version 09
HCheckStructure
HCheckStructure
Defines the mode for comparing data files.
Versions 09 and later
HDBCreation
New in version 09
HDBCreation
HDBCreation
Ends the description of the structure of an xBase data file by programming.
Versions 09 and later
HDBDescribeField
New in version 09
HDBDescribeField
HDBDescribeField
Describes by programming each item found in the structure of an xBase file described by HDBDescribeFile.
Versions 09 and later
HDBDescribeFile
New in version 09
HDBDescribeFile
HDBDescribeFile
Describes a file in dBase3 format (most common format) by programming.
Versions 09 and later
HDBDescribeIndex
New in version 09
HDBDescribeIndex
HDBDescribeIndex
Describes by programming the different index files that will be created.
Versions 09 and later
HDBIndex
New in version 09
HDBIndex
HDBIndex
Opens an xBase index file.
Versions 09 and later
HDBOpen
New in version 09
HDBOpen
HDBOpen
Opens the xBase data file and the "memo" file if it exists.
Versions 09 and later
HDBOpenNoLock
New in version 09
HDBOpenNoLock
HDBOpenNoLock
In single-user mode, opens an xBase data file without locking it.
Versions 09 and later
HDBSortType
New in version 09
HDBSortType
HDBSortType
Returns or modifies the sequence of text items in the xBase files.
Versions 09 and later
HDeclareExternal
New in version 09
HDeclareExternal
HDeclareExternal
Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file.
Versions 09 and later
HDeleteView
New in version 09
HDeleteView
HDeleteView
Destroys a view that was created beforehand. This function is using the former mechanism of views.
Versions 09 and later
HEndNoModif
New in version 09
HEndNoModif
HEndNoModif
Unlocks a file that was locked by the same program with HNoModif.
Versions 09 and later
HIndexingInProgress
New in version 09
HIndexingInProgress
HIndexingInProgress
Indicates that a reindex operation is currently performed on a HFSQL data file and returns the percentage of reindexing already performed.
Versions 09 and later
HInfoReplica
New in version 09
HInfoReplica
HInfoReplica
Returns information about the specified replica.
Versions 09 and later
HInitSubscriber
New in version 09
HInitSubscriber
HInitSubscriber
Initializes the range of automatic identifiers for the description file of subscriber replica (".RPL" extension).
Versions 09 and later
HLogInfo
New in version 09
HLogInfo
HLogInfo
Adds comments into the log when saving the logged operation.
Versions 09 and later
HLogRecreate
New in version 09
HLogRecreate
HLogRecreate
Used to re-create an empty log.
Versions 09 and later
HLogRestart
New in version 09
HLogRestart
HLogRestart
Restarts the log process on a file.
Versions 09 and later
HLogStop
New in version 09
HLogStop
HLogStop
Stops the log process of a file.
Versions 09 and later
HNoModif
New in version 09
HNoModif
HNoModif
Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy).
Versions 09 and later
HOpenConnection
New in version 09
HOpenConnection
HOpenConnection
Opens a connection to a specific database.
Versions 09 and later
HPost
New in version 09
HPost
HPost
Stores a unique computer number or identifier in order to use the log and transactions in network.
Versions 09 and later
HPrepareSQLQuery
New in version 09
HPrepareSQLQuery
HPrepareSQLQuery
Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query.
Versions 10 and later
HRecordDate
New in version 10
HRecordDate
HRecordDate
Returns the date and time of last write operation performed on a record found in a HFSQL file (Classic or Client/Server).
Versions 09 and later
HRegenerateFile
New in version 09
HRegenerateFile
HRegenerateFile
Regenerates a data file from its log.
Versions 09 and later
HRplDeclareLink
New in version 09
HRplDeclareLink
HRplDeclareLink
Declares a (1, 1) (0, n) link between two tables.
Versions 09 and later
HRplFilterProcedure
New in version 09
HRplFilterProcedure
HRplFilterProcedure
Defines the WLanguage procedure that will be called whenever a replication operation is performed on a specific file.
Versions 09 and later
HSetLog
New in version 09
HSetLog
HSetLog
Enables or disables the log management for a logged file.
Versions 09 and later
HSetReplication
New in version 09
HSetReplication
HSetReplication
Temporarily disables (or re-enables) the replication.
Versions 09 and later
HStatDate
New in version 09
HStatDate
HStatDate
Returns the date of the last update for the index statistics.
Versions 09 and later
HStatTime
New in version 09
HStatTime
HStatTime
Returns the time of the last update for the index statistics.
Versions 09 and later
HSubstDir
New in version 09
HSubstDir
HSubstDir
Associates the data directory specified in the analysis with a directory found on disk.
Versions 09 and later
HSynchronizeReplica
New in version 09
HSynchronizeReplica
HSynchronizeReplica
Synchronizes the master replica and the subscriber replica: the operations performed on one of the replicas are transferred into the other replica.
Caution:
  • The hWithFilter constant is not supported when using HExecuteQuery.
  • The replication, the log process, the external languages and the thumbnails are not supported.
  • HFSQL Client/Server is not available.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Optimizations
The controls such as Table controls or Combo Box controls based on files should not be used. We advise you to create a query used to fill the content of the Table or Combo Box control .
Furthermore, we advise you to display as less data as possible. For example, you should use search criteria instead of displaying an entire list of customers.
The number of "back and forth" connections between the server and the client computer must be limited. It may be better to temporarily store the data on the client computer rather than requesting data from the server (configuration data, list of users, ...).
See Optimizing the remote access for more details.
Minimum required version
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment