ApiTableRelate - cDbUpdateFunctionLibrary
Creates a relation between two tables.
Type: Function
Parameters: Handle hTableFrom Handle hTableTo Integer iColumnFrom Integer iColumnTo
Parameter |
Description |
hTableFrom |
A file handle to the table name to relate from. Same as the Filelist.cfg slot number. |
hTableTo |
A file handle to the table to relate to. |
iColumnFrom |
The column number to relate from. |
iColumnTo |
The column number to relate to. |
Syntax
Function ApiTableRelate Handle hTableFrom Handle hTableTo Integer iColumnFrom Integer iColumnTo Returns Boolean
Call: |
Get ApiTableRelate OrdHea.File_Number 9 Invt.File_Number 1 to bOK |
Description
Use it to create a relationship to another table. The file handles are the same as the file numbers in Filelist.cfg.
Example
Procedure OnUpdate
Boolean bOK
Get ApiTableRelate MyTable.File_Number 14 MyOtherTable 3 to bOK
End_Procedure