I have found one place where table names are handled. I have changed line 101 of SqlDesigner.cpp totableItem->setText(0,'"'+tableName+'"');. This has resulted in the table names in the Designer workspace to be protected by double quotes, but column names are still not being displayed.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I returned line 101 to its original state and ran designer against a PostgreSQL table using only lowercase table and column names, but the result is exactly the same. It appears QtRPT does not work with PosgreSQL yet? Curious, as I have demonstrated PyQt5.QtSql can work happily with PostgreSQL, as long as mixed-case table and column names are protected..
I still have not found where the query is built in QtRPT and would be very grateful if you could describe how this is done in your code, so I can have a chance to patch it on my system to see if it starts to work. "8-)
Last edit: owlbrudder 2019-01-17
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have found one place where table names are handled. I have changed line 101 of SqlDesigner.cpp to
tableItem->setText(0,'"'+tableName+'"');
. This has resulted in the table names in the Designer workspace to be protected by double quotes, but column names are still not being displayed.I returned line 101 to its original state and ran designer against a PostgreSQL table using only lowercase table and column names, but the result is exactly the same. It appears QtRPT does not work with PosgreSQL yet? Curious, as I have demonstrated PyQt5.QtSql can work happily with PostgreSQL, as long as mixed-case table and column names are protected..
I still have not found where the query is built in QtRPT and would be very grateful if you could describe how this is done in your code, so I can have a chance to patch it on my system to see if it starts to work. "8-)
Last edit: owlbrudder 2019-01-17