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;
What database and driver are you using ? That is the most important piece of missing information.
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.
in any case, now that you provided the dbms and driver (odbc) information, someone can possibly point you in the right direction.