PC SOFT

WINDEV的在线文档

  • Overview
  • Configuring the server for remote access
  • Programming
  • Accessing the database
  • Using H描述连接 and H改变连接
  • HFSQL functions that can be used in remote access
  • Optimizations
文档页面当前正在翻译。对于此延迟我们深表歉意。
您可以自愿地帮助我们翻译您想要的文档段落,然后只需通过以下地址与我们联系:info@cn.windev.com
产品
WinDevWebDev-服务器代码WebDev-浏览器代码WinDev Mobile报表和查询
平台
WindowsLinuxWindows MobileWindows PhoneWindows Store appsAndroidAndroid Widget iPhone/iPad
语言
JavaPHPAjax用户代码(MCU)外部语言
数据库
HFSQLHFSQL Client/Server存储过程HF 5.5OLE DBODBC本地访问

Overview
The remote access allows you to access all types of databases.

To do so, create an analysis accessing the third-party 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 the 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.
    • These elements must be copied from the "Programs" directory of WinDev to the server.
  2. Starting the "WDRemoteAccessServer" application on the server.
  3. Select 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 startup, ...
  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 H打开数据模型. For example:

// Open the remote analysis
H打开数据模型"MyAnalysis.wdd"""EDT_IPAddressEDT_UserEDT_PWD

The access to the data is performed by the Hxxx functions:

// Initialize the table
H读第一个CustomerName
只要H超出()=
...
H读下一个Customer
结束

Using H描述连接 and H改变连接

When using the remote access, you have the ability to call H描述连接 and H改变连接. For example:

// Connection to the RPC server
H连接远程访问"192.168.1.1""User""UserPassword",...
"C:\SALESMGT\SALESMGT.WDD""SalesMgtPassword"
H描述连接"MyConnection"""""" Server_SQLServer ""dbo",...
h本机访问.SQLServerH打开.读写""
H改变连接"*""192.168.1.1"

WinDevWindows

HFSQL functions that can be used in remote access

The HFSQL functions can be used when accessing a database by remote access.

The following functions are not available for the remote access:

10版本和更高版本
H记录日期
10新版本
H记录日期
H记录日期
Returns the date and time of the last write operation performed on a record found in a HFSQL file (Classic or Client/Server).
09版本和更高版本
H导入数据库表
H导入数据库表
Temporarily imports into the current analysis the description of a file from an existing HFSQL file.
09版本和更高版本
HDB创建
09新版本
HDB创建
HDB创建
Ends the description of the structure of the xBase data file by programming.
09版本和更高版本
HDB描述数据库表
HDB描述数据库表
Describes by programming a file in dBase3 format (most common format).
09版本和更高版本
HDB描述索引
09新版本
HDB描述索引
HDB描述索引
Describes by programming the different index files that will be created.
09版本和更高版本
HDB描述字段
09新版本
HDB描述字段
HDB描述字段
Describes by programming each item of the structure of an xBase file described by HDB描述数据库表.
09版本和更高版本
HDB索引
09新版本
HDB索引
HDB索引
Opens an xBase index file.
09版本和更高版本
HDB打开
09新版本
HDB打开
HDB打开
Opens the xBase data file and the "memo" file if it exists.
09版本和更高版本
HDB打开而不加锁
HDB打开而不加锁
In single-user mode, opens an xBase data file without locking it.
09版本和更高版本
HDB排序类型
09新版本
HDB排序类型
HDB排序类型
Returns or modifies the sequence of text items in the xBase files.
09版本和更高版本
H删除视图
09新版本
H删除视图
H删除视图
Destroys a view that was created beforehand. This function is using the former mechanism of views.
09版本和更高版本
H结束禁止修改
H结束禁止修改
Unlocks a file that was locked by the same program with H禁止修改.
09版本和更高版本
H管理日志
09新版本
H管理日志
H管理日志
Enables or disables the management of the log for a logged file.
09版本和更高版本
H管理复制
09新版本
H管理复制
H管理复制
Temporarily disables (or re-enables) the replication.
09版本和更高版本
H副本信息
09新版本
H副本信息
H副本信息
Returns information about the specified replica.
09版本和更高版本
H初始化订阅
09新版本
H初始化订阅
H初始化订阅
Initializes the range of automatic identifiers for the description file of a subscriber replica (".RPL" extension).
09版本和更高版本
H禁止修改
09新版本
H禁止修改
H禁止修改
Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy).
09版本和更高版本
H日志信息
09新版本
H日志信息
H日志信息
Adds comments into the log when saving the logged operation.
09版本和更高版本
H日志重建
09新版本
H日志重建
H日志重建
Used to re-create an empty log.
09版本和更高版本
H日志重启
09新版本
H日志重启
H日志重启
Restarts the log process on a file.
09版本和更高版本
H日志停止
09新版本
H日志停止
H日志停止
Stops the log process of a file.
09版本和更高版本
H打开连接
09新版本
H打开连接
H打开连接
Establishes a connection to a specific database.
09版本和更高版本
H计算机
09新版本
H计算机
H计算机
Stores a unique computer number or identifier in order to use the logs and the transactions.
09版本和更高版本
H准备SQL查询
09新版本
H准备SQL查询
H准备SQL查询
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.
09版本和更高版本
H重建数据库表
H重建数据库表
Regenerates a data file from its log.
09版本和更高版本
H当前重建索引
H当前重建索引
Indicates that a reindex operation is currently performed on a HFSQL data file and returns the percentage of reindexing already performed.
09版本和更高版本
H复制声明关系
H复制声明关系
Declares a (1,1) (0,n) link between two tables.
09版本和更高版本
H复制过滤器过程
H复制过滤器过程
Defines the WLanguage procedure that will be called whenever a replication operation is performed on a specific file.
09版本和更高版本
H统计的日期
09新版本
H统计的日期
H统计的日期
Returns the date of the last update for the index statistics.
09版本和更高版本
H统计的时间
09新版本
H统计的时间
H统计的时间
Returns the time of the last update for the index statistics.
09版本和更高版本
H替换目录
09新版本
H替换目录
H替换目录
Associates the data directory specified in the analysis with a directory found on disk.
09版本和更高版本
H同步副本
09新版本
H同步副本
H同步副本
Synchronizes the master replica and the subscriber replica: the operations performed on one of the replicas are transferred into the other replica.
09版本和更高版本
H检查结构
09新版本
H检查结构
H检查结构
Defines the mode for comparing the data files.

Caution:
  • The h.使用过滤器 constant is not supported when using H执行查询.
  • 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.