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