NO: Frontbase list columns

[Mike Matthews]

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