NO: Frontbase list columns

[David Walton]

Thanks Mike but there's only one user so that's not it. I wonder if there are different settings coming from the sql browser vs the $logon method.

David

On Dec 29, 2014, at 12:09 PM, Mike Matthews wrote:

> Might be who you are logging on as perhaps?  Unfortunately, I connect to Frontbase using StudioWorks, so I leave it alone.
> 
> 
> Mike Matthews,
> Managing Director, SQLWorks Software Ltd
> 
> Tel: +44 (0)1271 375999
> 
> Email: mike.matthews at sqlworks.co.uk
> 
> Web: www.sqlworks.co.uk
> 
> SQLWorks replaces Sage, ACT!, Opera, Access, SAP
> 
> On 29 Dec 2014, at 17:03, David Walton <omuser at roundog.com> wrote:
> 
>> 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
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com