To move a column within a table.
Type: Function
Parameters: Handle hTable, Integer iOldColumnNumber, Integer iNewColumnNumber
|
Parameter |
Description |
|
hTable |
The table number as referenced to by Filelist.cfg |
|
iOld |
The current field number |
|
iNew |
The new field number to move to |
|
bIsSQLType |
Pass True if the iOld field number is an SQL field/column |
Syntax
Function ApiIndexMove Handle hTable Integer iOldColumn Integer iNewColumn Returns Boolean
|
Call: |
Get ApiIndexMove Customer.File_Number 1 10 True to bOK |
Description
Use it to move an existing field to another position in a table.
Example
Procedure OnUpdate
Boolean bOK
Get ApiIndexMove Customers.File_Number 3 5 False to bOK
End_Procedure