NO: Frontbase list columns
ben.butler at w16.co.uk
ben.butler at w16.co.uk
Mon Dec 29 11:56:25 EST 2014
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.
More information about the omnisdev-en
mailing list