NO: Frontbase list columns

[David Walton]

And some other weird behavior. If I open a connection to frontbase with the session manager I  can see the tables and fields in the browser. If I open the connection using the $logon method, I can't see the tables and fields in the browser. Is there some setting I'm missing when using $logon?

Thanks,

David

On Dec 29, 2014, at 11:04 AM, David Walton wrote:

> So I'm using the following and the result list has no lines. Is this a known issue with the frontbase dam or is this code wrong?
> 
> Do tstatement.$columns(ltablelist.ltable) Returns #F
> Do tstatement.$fetch(list,kFetchAll,kFalse) Returns #F
> 
> ... where ltablelist.ltable is the table name and "list" is the result set I want to populate. The flag returns true for each of these.
> 
> Thanks,
> 
> 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