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.
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.
- Gary Collins
- Tuesday, 27 February 2018 01:12 AM UTC
To be clear, I am not looking to see the pbcat tables, I want to see my db tables.
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.
This happens to me now and again. Disconnecting en re-connecting usually fixes it.
- Gary Collins
- Monday, 26 February 2018 15:13 PM UTC
- Page :
However, you are not allowed to reply to this question.