UtilEnumerateOverlapFields - cDbUpdateFunctionLibrary
To enumerate overlap fields for a column. Pass a table handle (filelist.cfg number) and a column number. Returns a string array.
Type: Function
Parameters: Handle hTable, Integer iColumn
Parameter |
Description |
hTable |
DataFlex, MSSQLDRV_ID, DB2_DRV_ID, ODBC_DRV_ID, ORAFLEX, SQLFLEX, MDSPgSQL or MDSMySQL. |
iTable |
Database type; Microsoft SQL Server, IBM DB2, Oracle, MySQL or PostgreSQL. This is a enumeration type and can be any of; EN_DbTypeDataFlex, EN_DbTypeMSSQL, EN_DbTypeMySQL, EN_DbTypeOracle, EN_DbTypeDB2 or EN_DbTypePostgre. |
Syntax
Function UtilEnumerateOverlapFields Handle hTable Integer iColumn Returns String[]
Call: |
Get UtilEnumerateOverlapFields MyTable.File_Number 4 to sColumnsArray |
Description
To get a list of all fields/columns that makes up an overlap field.
Example
Procedure OnClick
String[] sColumnArray
Integer iSize iCount
Get UtilEnumerateOverlapFields SomeTable.File_Number 3 to sColumnArray
Move (SizeOfArray(ColumnTypes)) to iSize
Decrement iSize
For iCount from 0 to iSize
Showln sColumnArray[iCount]
Loop
End_Procedure