Topic complex |
Table functions |
Function |
sortmark() |
Short |
Sorts the marking list |
Syntax |
SORTMARK(db : INTEGER; IndDef : STRING) : INTEGER |
Parameter |
db : Table handle from OpenDB
IndDef : Index definition |
Return |
1 : sorted successfully
0 : error |
See also: |
|
Description |
An index definition has the following structure:
Hierarchic index::=Field-Def{","Field-Def}.
Field-Def::=["$"]Field[":"Number]
Field::=Field identifier|Field number
Calculated Index::="("Expression")"[":"Number]
Examples:
Hierarchic Index: Name,Firstname:1,postcode
Calculated Index: (Name+'/'+Firstname):40
The optional specification :Number after a field (resp. after an expression) is evaluated only at string fields (resp. string expressions) and defines how many chars of the string are taken over to the index information.
The following restrictions of an index description are valid at present (Version 6.2.6):
The expression of a calculated index must not exceed 40 chars.
The index information (sum of all hierarchic levels) may contain maximal 256 Bytes.
|