NO: Frontbase list columns

[David Walton]

Thanks Kelly. This is really helpful.

Happy Holidays!

David

On Dec 23, 2014, at 5:45 PM, Kelly Burgess wrote:

> 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.
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com