NO: Frontbase list columns

[Mike Matthews]

But there is a FB user called _system that should be used, and no password by default.  You need to use that value in the Browser when using the session manager.

Mike






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:18, David Walton <omuser at roundog.com> wrote:

> 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
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com