Cannot see index columns in SQL Explorer (Oracle DB) 
Author Message
 Cannot see index columns in SQL Explorer (Oracle DB)

BDE 5.11  - ORACLE 8 DRIVER UPDATE 1
O8i on AIX, or O873 on NT

When I wanna use SQL Explorer to check my DB structure,
I cannot see the column names in the tree (left part of the screen),
either not when I click on "Text" :
here is what I get for instance :
CREATE UNIQUE INDEX LOVEFRANCE.POS_CLEP ON LOVEFRANCE.CSTDF006
("<vide>")        <------------------here is the problem
  TABLESPACE INDX
  PCTFREE 10
  INITRANS 2
  MAXTRANS 255
  STORAGE (INITIAL 12288
    NEXT 12288
    MINEXTENTS 1
    MAXEXTENTS 121
    PCTINCREASE 50
    FREELISTS 1
    FREELIST GROUPS 1)

BTW - "Vide" in french means "Null"

Any idea ? TIA, Nicole



Wed, 18 Jun 1902 08:00:00 GMT
 Cannot see index columns in SQL Explorer (Oracle DB)

BDE 5.11  - ORACLE 8 DRIVER UPDATE 1
O8i on AIX, or O873 on NT

When I wanna use SQL Explorer to check my DB structure,
I cannot see the column names in the tree (left part of the screen),
either not when I click on "Text" :
here is what I get for instance :
CREATE UNIQUE INDEX LOVEFRANCE.POS_CLEP ON LOVEFRANCE.CSTDF006
("<vide>")        <------------------here is the problem
  TABLESPACE INDX
  PCTFREE 10
  INITRANS 2
  MAXTRANS 255
  STORAGE (INITIAL 12288
    NEXT 12288
    MINEXTENTS 1
    MAXEXTENTS 121
    PCTINCREASE 50
    FREELISTS 1
    FREELIST GROUPS 1)

BTW - "Vide" in french means "Null"

Any idea ? TIA, Nicole



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Want tools to print tables structure and index seen on Database Explorer

2. Oracle Thin JDBC from Explorer 4.0 - applet cannot connect

3. cannot connect to SQL Server thru ODBC, yet Enterprise mgr sees it

4. cannot connect to SQL Server thru ODBC, yet Enterprise mgr sees it

5. SAS Import sees column labels not column names

6. SQL Explorer Error: List index out of bounds

7. SQL explorer from D3 shows wrong indices with MSACCESS

8. Cannot create index on a column of bit data type

9. Unique indexes and constraints cannot be created on columns that allow null

10. Cannot delete people from my db after indexing!!!

11. profiler cannot save all of textData column to file or db table


 
Powered by phpBB® Forum Software