DbServer.Update Method (Usual, Usual, Usual, Usual) | |
Update this server with data from another server or table.
Namespace:
XSharp.VO.SDK
Assembly:
XSharp.VORDDClasses (in XSharp.VORDDClasses.dll) Version: 2.19
Syntax VIRTUAL METHOD Update(
oDbServer,
cbKey,
lRandomFlag,
cbReplace
) AS LOGIC CLIPPER
[ClipperCallingConventionAttribute(new string[] { ... })]
public virtual bool Update(
Usual oDbServer = default,
Usual cbKey = default,
Usual lRandomFlag = default,
Usual cbReplace = default
)
Request Example
View SourceParameters
- 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 |
---|
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