Click or drag to resize

DbServer.AppendDB Method

X#
Append new records to the table from another DBF file.

Namespace:  VO
Assembly:  VORDDClasses (in VORDDClasses.dll) Version: 2.19
Syntax
 VIRTUAL METHOD AppendDB(
	oFSSource,
	aFieldList,
	cbForBlock,
	cbWhileBlock,
	uScope,
	cDriver,
	aRDD
) AS USUAL CLIPPER
Request Example View Source

Parameters

oFSSource (Optional)
Type: Usual
A string or filespec object that specifies the source file, which is opened in shared, read-only mode, and can be open elsewhere in this or some other application. This function attempts to open oFSSource in shared mode. If the file does not exist, a runtime error is raised. If the file is successfully opened, the operation proceeds. Refer to the 'Concurrency Control' chapter in the Programmer's Guide for more information on resolving concurrency conflicts.
aFieldList (Optional)
Type: Usual
An array of fields from the source file that are to be included. The default is all fields.
cbForBlock (Optional)
Type: Usual
The condition evaluated for each record in the scope; if TRUE, the record is included in the processing. It provides the same functionality as the FOR clause of record processing commands.
cbWhileBlock (Optional)
Type: Usual
The condition evaluated for each record from the first record until the condition returns FALSE. It provides the same functionality as the WHILE clause of record processing commands.
uScope (Optional)
Type: Usual
The range of records to process, providing the same functionality as the ALL, REST and NEXT clauses of record processing commands.
ValueDescription
DBSCOPEALLThe scope is all the records in the table. This is the default, although if a WHILE condition is specified, the scope becomes DBSCOPEREST.
DBSCOPERESTThe scope is the remaining records in the table from the current position.
<nRecords> The scope is the next nRecords records.
cDriver (Optional)
Type: Usual
The name of the RDD that will service the data server. If not specified, the default RDD as determined by RDDSetDefault() is used.
aRDD (Optional)
Type: Usual
A one-dimensional array with the names of RDDs from which the main RDD inherits special functionality. This allows you to use RDDs with special capabilities, like encryption or decryption, for different data servers with different database drivers. These RDDs overlay special functions of the main RDD (specified with the cDriver argument). If multiple RDDs (specified with this argument) implement the same function, the function associated with the last RDD in the list takes precedence. If aRdds is omitted, no additional RDDs are assumed.

Return Value

Type: Usual
TRUE if successful; otherwise, FALSE (although some records still might have been processed).
Remarks
Sends a NotifyIntentToMove message before the operation.
Sends a NotifyFileChange message, if any record was appended.
See Also