ApiIndexCreateByFieldNames - cDbUpdateFunctionLibrary
Creates a new table index.
Type: Function
Parameters: Handle hTable, Integer iIndex, String sFields
Parameter |
Description |
hTable |
The table number as referenced to by Filelist.cfg |
iIndex |
Number of the index |
sFields |
A comma separated string with field/column names |
Syntax
Function ApiIndexCreate Handle hTable Integer iIndex String sFieldNames Returns Boolean
Call: |
Get ApiIndexCreate MyTable.File_Number 1 "Field1,Field2,Field3" to bOK |
Description
Use it to create a new index.
Example
Procedure OnUpdate
Boolean bOK
Get ApiIndexCreate Customers.File_Number 1 "Name,Address,City" to bOK
End_Procedure