Menu

How do I display fields within my table in the SQL diagram?

owlbrudder
2019-01-12
2019-01-16
<< < 1 2 (Page 2 of 2)
  • owlbrudder

    owlbrudder - 2019-01-16

    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.

     
    • owlbrudder

      owlbrudder - 2019-01-16

      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
<< < 1 2 (Page 2 of 2)

Log in to post a comment.