ApiIndexCreate - cDbUpdateFunctionLibrary

Creates a new table index.

Parameters: Handle hTable, Integer iIndex, Integer iSegments, Integer iSegment1, Integer iSegment2... Integer iSegment10

Parameter	Description
hTable	The table number as referenced to by Filelist.cfg
iIndex	Number of the index
iSegments	Number of index segments (Max 10 segments)
iSegment1	Field number for segment number 1
iSegment2	Optional. Field number for the segment number
iSegment3	Optional. Field number for the segment number
iSegment4	Optional. Field number for the segment number
iSegment5	Optional. Field number for the segment number
iSegment6	Optional. Field number for the segment number
iSegment7	Optional. Field number for the segment number
iSegment8	Optional. Field number for the segment number
iSegment9	Optional. Field number for the segment number
iSegment10	Optional. Field number for the segment number

Syntax

Function ApiIndexCreate Handle hTable Integer iIndex Integer iSegments Integer iSgmnt1 Integer iSgmnt2 Integer iSgmnt3 Integer iSgmnt4 Integer iSgmnt5 Integer iSgmnt6 Integer iSgmnt7 Integer iSgmnt8 Integer iSgmnt9 Integer iSgmnt10 Returns Boolean

Call:

Get ApiIndexCreate Customer.File_Number 1 2 1 0 to bOK

Description

Use it to create a new index.

Note: If the index to create only consists of 1 segment you only need to pass 4 parameters. The others are optional.

Example

Procedure OnUpdate

Boolean bOK

Get ApiIndexCreate Customers.File_Number 1 2 1 0 to bOK

End_Procedure