NO: Frontbase list columns

[Kelly Burgess]

Hi David,

Here are some snippets re FrontBase tables and columns.

Kelly

------

Do statementObj.$tables() Returns #F
If flag true
   Do statementObj.$fetch(pTableList,kFetchAll,kTrue) Returns fetchStatus     ;; return tables list in [pTableList]


Do statementObj.$indexes(iTables.TableOrViewName,kStatementIndexAll) Returns #F
If flag true
   Do statementObj.$fetch(indexList,kFetchAll) Returns fetchStatus


Do statementObj.$columns(pTableName) Returns #F
If flag true
   Do statementObj.$fetch(pColumnsList,kFetchAll) Returns fetchStatus     ;; return columns list in [pColumnsList]


;  column-data columns fetched into [pColumnsList]: (by the FrontBase DAM)
;  1  DatabaseOrCatalog     ;; DatabaseName, e.g. 'TDMDocs'
;  2  Owner     ;; Name of user that owns the column, e.g. '_SYSTEM'
;  3  ColumnName     ;; Name of a column in the table, e.g. 'ADD_ID'
;  4  OmnisDataTypeText     ;; Omnis data type as text, e.g. 'Long Integer'
;  5  OmnisDataType     ;; Omnis data type property, e.g. 'integer'
;  6  OmnisDataSubType     ;; Omnis data subtype property, e.g. 'longint'
;  7  SQLDataType     ;; SQL data type, e.g. 'INT'
;  8  Length     ;; data size, e.g. 0 (numbers) or some character length maximum
;  9  Scale     ;; ?? e.g. 0
;  10  Null     ;; CanBeNull? - e.g. true
;  11  Index     ;; IsIndexed? - e.g. true
;  12  PrimaryKey     ;; IsPrimaryKey? - e.g. true
;  13  Description     ;; description e.g. '(No column description available.)'
;  14  DamInfoRow     ;; A row of database specific information about the table or view. This may be empty.