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