NO: Frontbase list columns

David Walton omuser at roundog.com
Mon Dec 29 12:03:45 EST 2014


Yes. Queries work and I can fetch data but I cannot see the data tables in the sql browser. I thought that might have some connection to getting no columns when fetching the $columns result.

Thanks,

David

On Dec 29, 2014, at 11:56 AM, ben.butler at w16.co.uk wrote:

> are you switching to the correct database when $logon
> 
> Ben
> 
> On 29 December 2014 16:53:46 GMT+00:00, David Walton <omuser at roundog.com> wrote:
>> 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
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> -- 
> Sent from my Android device with K-9 Mail. Please excuse my brevity.
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com




More information about the omnisdev-en mailing list