NO: Frontbase list columns

[David Walton]

Yes, that is the one I'm using. Not sure why I can see tables in one case and not in the other. Same DAM...?

David

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

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