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.
- You are here:
- Home
- Q&A
- Q&A
- PowerBuilder
- How to get tables to appear in Database painter for MySQL database
- Gary Collins
- PowerBuilder
- Monday, 26 February 2018 01:28 AM UTC
- Tuesday, 27 February 2018 00:28 AM UTC
- PowerBuilder
- # 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:
-
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.
-
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).
-
-
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.
- Monday, 26 February 2018 15:42 PM UTC
- PowerBuilder
- # 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
- Gary Collins
- Monday, 26 February 2018 16:16 PM UTC
-
Helpful Loading... Helpful 0
- Monday, 26 February 2018 07:54 AM UTC
- PowerBuilder
- # 3
This happens to me now and again. Disconnecting en re-connecting usually fixes it.
Gerry.
- Gary Collins
- Monday, 26 February 2018 15:13 PM UTC
-
Helpful Loading... Helpful 0
- Page :
- 1
However, you are not allowed to reply to this question.
To be clear, I am not looking to see the pbcat tables, I want to see my db tables.