Click or drag to resize

DbServer.Update Method

Update this server with data from another server or table.

Namespace:  VO
Assembly:  VORDDClasses (in VORDDClasses.dll) Version: 2.5
Syntax
 VIRTUAL METHOD Update(
	oDbServer AS USUAL,
	cbKey AS USUAL,
	lRandomFlag AS USUAL,
	cbReplace AS USUAL
) AS USUAL

Parameters

oDbServer
Type: Usual
The database that provides the new data.
cbKey
Type: Usual
The key field that defines how records are matched between the servers.
lRandomFlag
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
Type: Usual
Code block that performs the update operations.

Return Value

Type: Usual
TRUE if successful; otherwise, FALSE, although even with FALSE, some records may have been updated.  This can happen if the operation failed halfway through because of technical problems.
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