1. Sylvain .
  2. PowerBuilder
  3. Wednesday, 3 November 2021 12:38 PM UTC

When I try to edit any datawindow data source PB is given me the following error and cannot go in graphic mode.

      Table "table_name" as no columns; possible invalid table format...

 

The problem occurs also when I try to create new datawindow PB cannot find any tables.

 

The problem come from the SQL (show below) the where clause look for the table_schema 'system', is there a way to tell PB to look to another specific schema for example 'MY_SCHEMA' ? 

 

SELECT TABLE_NAME,TABLE_COMMENT,IF(TABLE_TYPE='BASE TABLE', 'TABLE', TABLE_TYPE),TABLE_SCHEMA

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_SCHEMA LIKE 'system'

AND ( TABLE_TYPE='BASE TABLE' OR TABLE_TYPE='VIEW' )

AND TABLE_NAME LIKE 'RS\\_TRANSPORT' ORDER BY TABLE_SCHEMA, TABLE_NAME;

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 3 November 2021 19:04 PM UTC
  2. PowerBuilder
  3. # 1

Hi Sylvain;

  Please note that PowerBuilder does not officially support MySQL.

Regards ... Chris

Comment
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Wednesday, 3 November 2021 13:45 PM UTC
  2. PowerBuilder
  3. # 2

go to the database profile setup, system tab.  enter the table owner

 

Comment
  1. mike S
  2. Wednesday, 3 November 2021 14:42 PM UTC
did you disconnect/reconnect to the database after you did that?

What database and driver are you using ? That is the most important piece of missing information.
  1. Helpful
  1. Sylvain .
  2. Wednesday, 3 November 2021 15:28 PM UTC
Yes I even exited PB completely and went back in.

I am connected to MySQL 8 database using an ODBC supply be them (I know not supported by PB).

That was working perfectly up to a couples of weeks ago something must have change that I'm not aware of, I can work with it in syntax mode but it is longer to type the SQL...

I will leave it like that for now, thank you again for your time.
  1. Helpful
  1. mike S
  2. Wednesday, 3 November 2021 17:46 PM UTC
i don't know why appeon des not enhance syntax mode in datawindows. Graphical is quicker for simple stuff because syntax isn't enhanced, but graphical has a lot of limitations, often generates poor sql (right out joins?! ) and will also generate incorrect sql.



in any case, now that you provided the dbms and driver (odbc) information, someone can possibly point you in the right direction.
  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.