Click or drag to resize

DbServer.Update Method (Usual, Usual, Usual, Usual)

X#
Update this server with data from another server or table.

Namespace:  XSharp.VO.SDK
Assembly:  XSharp.VORDDClasses (in XSharp.VORDDClasses.dll) Version: 2.21
Syntax
Copy
 VIRTUAL METHOD Update(
	oDbServer,
	cbKey,
	lRandomFlag,
	cbReplace
) AS LOGIC CLIPPER
Request Example View Source

Parameters

oDbServer (Optional)
Type: Usual
The database that provides the new data.
cbKey (Optional)
Type: Usual
The key field that defines how records are matched between the servers.
lRandomFlag (Optional)
Type: Usual
Indicates if the records in the other database are allowed to be in random order. If FALSE or not specified, the other database must be ordered on the specified key.
cbReplace (Optional)
Type: Usual
Code block that performs the update operations.

Return Value

Type: Logic
TRUE if successful; otherwise, FALSE (although some records still might have been processed).
Remarks
Tip Tip
This method requires a file lock or exclusive access.
Sends a NotifyFileChange message upon completion.
There are two different formulations of the matching relationship between the two servers. If lRandomFlag is TRUE, this server must be indexed on the specified key, but the other server can be in any order; if lRandomFlag is not specified or is FALSE, both servers must be indexed or sorted on the specified key. If there is more than one record in this server with matching key fields, only the first one is updated.
See Also