Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved How to get tables to appear in Database painter for MySQL database

  1. Issue
-1
Votes
Undo
  1. Gary Collins
    Gary Collins
  2. PowerBuilder
  3. Monday, 26 February 2018 01:28 AM UTC

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.

  1. ASE
Generate .Net Assemblies in PB 2017 R2 - Failed to...
Windows 10 Mail (Internal)
Responses (3)
Govinda Lopez @Appeon
Govinda Lopez @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 27 February 2018 00:28 AM UTC
  2. PowerBuilder
  3. # 1

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
Gary Collins
  1. Gary Collins
  2. Tuesday, 27 February 2018 01:12 AM UTC
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. Helpful
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Monday, 26 February 2018 15:42 PM UTC
  2. PowerBuilder
  3. # 2

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
Gary Collins
  1. Gary Collins
  2. Monday, 26 February 2018 16:16 PM UTC
No.  I can run queries, but cannot see tables at all - not in DW painter, not in DB painter.

  1. Helpful
There are no comments made yet.
Gerry Whitmarsh
Gerry Whitmarsh Accepted Answer Pending Moderation
  1. Monday, 26 February 2018 07:54 AM UTC
  2. PowerBuilder
  3. # 3

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

Gerry.

Comment
Gary Collins
  1. Gary Collins
  2. Monday, 26 February 2018 15:13 PM UTC
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. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.