Xmas wishes

[ben.butler at w16.co.uk]

much love to one and all,  I hope you have a great Xmas and new year. 

On 23 December 2014 22:51:28 GMT+00:00, David Walton <omuser at roundog.com> wrote:
>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
>
>_____________________________________________________________
>Manage your list subscriptions at http://lists.omnis-dev.com

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.