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.7
	oDbServer AS USUAL := NIL,
	cbKey AS USUAL := NIL,
	lRandomFlag AS USUAL := NIL,
	cbReplace AS USUAL := NIL
Request Example View Source


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: 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.
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