ApiColumnMove - cDbUpdateFunctionLibrary
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 |
iLength |
The length for the field in the new position |
iPrecision |
The precision for the field in the new position |
Syntax
Function ApiColumnMove Handle hTable Integer iOldColumn Integer iNewColumn Boolan bIsSQL Integer iLength Integer iPrecision Returns Boolean
Call: |
Get ApiColumnMove Customer.File_Number 1 10 True 200 0 to bOK |
Description
Use it to move an existing field to another position in a table.
Example
Procedure OnUpdate
Boolean bOK
Get ApiColumnMove Customers.File_Number 3 5 False 12 2 to bOK
End_Procedure