1. Gary Collins
  2. PowerBuilder
  3. Monday, 26 February 2018

I can access the tables, run queries, etc.  However, when I click on the + next to Tables in the treeview for the Objects window, nohting shows up.

Govinda Lopez Accepted Answer Pending Moderation
0
Votes
Undo

Hi Gary,

 

Please try this:

 

Displaying the PowerBuilder extended attribute system tables

PowerBuilder updates the extended attribute system tables automatically whenever you change the information for a table or column. The PowerBuilder extended attribute system tables are different from the system tables provided by your DBMS.

You can display and open PowerBuilder extended attribute system tables in the Database painter just like other tables.

v         To display the PowerBuilder extended attribute system tables:

  1. In the Database painter, highlight Tables in the list of database objects for the active connection and select Show System Tables from the pop-up menu.

     
  2. The PowerBuilder extended attribute system tables and DBMS system tables display in the tables list, as follows:

    • PowerBuilder system tables

    The five system tables are: pbcatcol, pbcatedt, pbcatfmt, pbcattbl, and pbcatvld.

    • DBMS system tables

    The system tables supplied by the DBMS usually have a DBMS-specific prefix (such as sys or dbo).

     
  3. Display the contents of a PowerBuilder system table in the Object Layout, Object Details, and/or Columns views.

For instructions, see the Users Guide.

Do not edit the extended attribute system tables

Do not change the values in the PowerBuilder extended attribute system tables.

Comment
Right clicking on the connection in the database painter and choosing Show system tables does nothing.  The tables are there.  I can query them in the ISQL session tab, I can import from a select * on the table, etc..  I cannot see them in the tables list in the datawindow painter, nor do they appear when I expand the "Tables" treeview item in the database painter.



 



To be clear, I am not looking to see the pbcat tables,  I want to see my db tables.

  1. Gary Collins
  2. Tuesday, 27 February 2018
There are no comments made yet.
  1. Tuesday, 27 February 2018
  2. PowerBuilder
  3. # 1
Olan Knight Accepted Answer Pending Moderation
0
Votes
Undo

Have you ever been able to see the tables?

There are a set of PBCAT scripts that need to be run in order for the PowerBuilder tools to be able to see the tables. Those scripts should be located on the INSTALL disks for your version of PowerBuilder. Sadly, I cannot remember precisely where they would be located.

 

Later -

Olan

Comment
No.  I can run queries, but cannot see tables at all - not in DW painter, not in DB painter.

  1. Gary Collins
  2. Monday, 26 February 2018
There are no comments made yet.
  1. Monday, 26 February 2018
  2. PowerBuilder
  3. # 2
Gerry Whitmarsh Accepted Answer Pending Moderation
0
Votes
Undo

This happens to me now and again. Disconnecting en re-connecting usually fixes it.

Gerry.

Comment
I cannot see it and I have re-connected and disconnected / connected a dozen times or more. Any other ideas?  I read something about grant permissions on tables.  Any idea what specific grant (SQL statement) gets the info for the tables? 

  1. Gary Collins
  2. Monday, 26 February 2018
There are no comments made yet.
  1. Monday, 26 February 2018
  2. PowerBuilder
  3. # 3
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.