Click or drag to resize

DbServer.Sort Method

Copy records to another database file in sorted order.  If neither conditions nor scope is passed to the method, it is subject to the general server scope.

Namespace:  VO
Assembly:  VORDDClasses (in VORDDClasses.dll) Version: 2.7
	oFSTarget AS USUAL := NIL,
	aFieldList AS USUAL := NIL,
	cbForBlock AS USUAL := NIL,
	cbWhileBlock AS USUAL := NIL,
	uScope AS USUAL := NIL
Request Example View Source


oFSTarget (Optional)
Type: Usual
The file to which the records is copied.
aFieldList (Optional)
Type: Usual
An array of fields to be used as sort keys.  If an array of strings is specified, you may optionally add a sort key, after the field name; /A (to sort in dictionary order), /C (to ignore capitalization), or /D (to sort in descending order).  The default setting is /A.
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 current 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 Value Description DBSCOPEALL The scope is all the records in the table.  This is the default, although if a WHILE condition is specified, the scope becomes DBSCOPEREST. DBSCOPEREST The scope is the remaining records in the table from the current position. <nRecords> The scope is the next <nRecords> records.

Return Value

Type: Usual
TRUE if successful; otherwise, FALSE.  Note that after a FALSE indication, some records can have been copied: the operation can have failed halfway through because of lock conflicts or technical problems.
Sends a NotifyIntentToMove message before the operation.  Sends a NotifyRecordChange message upon completion. This method does not open the new file, it simply creates the file on disk.  If you want to open it afterwards, you simply instantiate it directly:
2oDB2 := DBServer{oFSTarget}
See Also