Activity for owlbrudder
-
owlbrudder posted a comment on discussion General Discussion
Ah - looks as though i need to install qtlinguist. Progress is being made ...
-
So simple! I'm now hitting a problem compiling QtRptDesigner, because i am trying to use Fedora 33 default environment which is qt5. I could not find how to install QtScript for qt4 on this platform.
-
New user here, so I am sure to be doing something wrong. Spent a career writing software and now retired. This is my first time with Qt. I would appreciate being pointed in the right direction. I am trying to compile from the source for 2.2.1 and getting an error when the compiler hits line 1522 in qtrpt.cpp qScriptRegisterSequenceMetaType<QList<RptPageObject*> >(m_globalEngine); The error reported is: In file included from /usr/include/QtGui/qtextoption.h:47, from /usr/include/QtGui/qpainter.h:51,...
-
New user here, so I am sure to be doing something wrong. Spent a career writing software and now retired. This is my first time with Qt. I would appreciate being pointed in the right direction. I am trying to compile from the source for 2.2.1 and getting an error when the compiler hits line 1522 in qtrpt.cpp qScriptRegisterSequenceMetaType<QList<RptPageObject*> >(m_globalEngine); The error reported is: In file included from /usr/include/QtGui/qtextoption.h:47, from /usr/include/QtGui/qpainter.h:51,...
-
I have just performed a fresh git download and built the project. I have found QtRptDemo displays data on example10,as one example, but QtRptDesigner does not, even when I ensure the full pathname of example.sqlite is set in the database name. I have attached pdfs of the two different results. In an attempt to report on a PostgreSQL database, I set the database details in the designer and changed example10 to show a single field - lngMR_Number - in place of the original fields. QtRptDesigner shows...
-
I have just performed a fresh git download and built the project. I have found QtRptDemo displays data on example10,as one example, but QtRptDesigner does not, even when I ensure the full pathname of example.sqlite is set in the database name. I have attached pdfs of the two different results. In an attempt to report on a PostgreSQL database, I set the database details in the designer and changed example10 to show a single field - lngMR_Number - in place of the original fields. QtRptDesigner shows...
-
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...
-
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.
-
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.
-
I executed a [doug@womble PyQt5Rpt]$ find . -exec grep -li "select\*from" {} 2>/dev/null \; [doug@womble PyQt5Rpt]$ in the top directory of my QtRPT tree, but it turned up no hits as you can see. If I could work out where you are building the tokens to pass to a 'select' on the database, I could try hacking the code to insert " at each end of the token. Can you point me in the right direction?
-
I executed a [doug@womble] PyQt5Rpt]$ find . -exec grep -li "select\*from" {} 2>/dev/null \; [doug@womble PyQt5Rpt]$ in the top directory of my QtRPT tree, but it turned up no hits. If I could work out where you are building the tokens to pass to a 'select' on the database, I could try hacking the code to insert " at each end of the token. Can you point me in the right direction?
-
Yes that is true, but it is QtReportDesigner which attempts to extract column names from tables to display in the workspace. If your code to select the field names is not protecting the table name, the result will what I am seeing. QtReportDesigned needs to query the field names of "tablename" not just tablename. Is it enclosing the table name in double quotes?
-
I found the problem, see my added comment above. The table and field names are in mixed case like tblMR_Details.lngMR_Number, so each identifier has to be protected by double quotes in the query string: select "lngMR_Number" from "tblMR_Details". I expect the query strings produced bt QtRPT do not protect identifiers to preserve case?
-
I definitely have the correct drivers. The database uses mixed case table and column identifiers, so each must be protected by " such as self.qryString = 'select * from "tblMR_Details"' I have built a PyQt5 application which reads the tblMR_Details table - see attached acreenshot.
-
I definitely have the correct drivers. The database uses mixed case table and column identifiers, so each mut be protected by " such as self.qryString = 'select * from "tblMR_Details"' I have built a PyQt5 application which reads the tblMR_Details table - see attached acreenshot.
-
By the way, the table names and column names are in camelCase like this: tblMR_Details.lngMR_Number. I am building a simple test harness and all my attempts to execute a query return -1 rows. It may be that QSqlQuery cannot handle mixed case names like that?
-
"hmmm, i didnt check with postgres. " If you could point me to where to begin, I could have a go at debugging the code? I was a good C coder in my time, but still getting to understand C++. I have all the development tools I need, I think. When I say 'debug', what I mean is that something on my system is obviously different from what it on your system, or it would all work, so I need to debug QtRPT on MY computer. I did not mean to suggest there are bugs in your code and if that is what you thought,...
-
"hmmm, i didnt check with postgres. " If you could point me to where to begin, I could have a go at debugging the code? I was a good C coder in my time, but still getting to understand C++. I have all the development tools I need, I think.
-
Gotta go - catch up in the morning our time (UTC+10).
-
Yes, this is a copy of a live database.
-
Good question. I believe I have a Qt5 driver for PostgreSQL - not sure about sqlite. I will double-check tomorrow. Thanks for your quick responses, by the way - your help is greatly appreciated. I expect I would not even see the table structure of sqlite if I did not have a driver for it and would also not see the PostgreSQL tables names, would I?
-
By the way, I am using python 3.7.2 and Qt5.
-
Your example16.xml appears to use a populated database,? Attached is the output PDF.
-
Do any of your examples use sqlite with a populated database? If not, I will hack something together in the morning - 9pm here now.
-
Do any of your examples ise sqlite with a populated database? If not, I will hack something together in the morning - 9pm here now.
-
DB is PostgreSQL 10.6
-
Example 10.xml is exactly what I expected the SQL diagram to look like. When I DND a table from my tree to the workplace, all I see is the table name rectangle, as shown in my screenshots. Double-clicking on that rectangle brings up the Object Property dialog with the name of the table and an empty list of names.
-
Yes, in the SQL diagram they do, but the tables are fully poputlated with columns and data.
-
I have built QtReportDesigner on my Linux box and most of it works well, but I have not been able to expand a table in the SQL diagram to show its fields, in order to set relationships with another table. What am I doing wrong? See attached screenshots, which show the connection being confimed and the dialog allowing me to connect fields, but the lists of available fields are empty.
-
I have built QtReportDesigner on my Linux box and most of it works well, but I have not been able to expand a table in the SQL diagram to show its fields, in order to set relationships with another table. What am I doing wrong? See attached screenshots, which show the connection being confimed and the dialog allowing me to connect fields, but the lists of available fields are empty.
-
I have built QtReportDesigner on my Linux box and most of it works well, but I have not been able to expand a table in the SQL diagram to show its fields, in order to set relationships with another table. What am I doing wrong? See attached screenshot, which shows the connection success and the table header of a table with many fields.
-
I have built QtReportDesigner on my Linux box and most of it works well, but I have not been able to expand a table in the SQL diagram to show its fields, in order to det relationships with another table. What am I doing wrong? See attached screenshot, which shows the connection success and the table header of a table with many fields.
-
I have at last been able to run the demo on my Liux box and I am delighted with the features you provide. The demos for Charts and Barcode did not work, so I will look at why. Now to work out how to invoke it from PyQt5 ...
-
QtRptDesigner.pro lacked this line: LIBS += -L$${DEST_DIRECTORY}/lib -lQtXlsx Once I added it, the compile was successful.
-
More build errors, I'm afraid. The first one puzzles me, because /home/doug/Downloads/PyQt5Rpt/qtrpt-code_git/bin/debug/lib/libQtXlsx.so exists . I must be mis-reading the error line. "8-[ /usr/bin/ld: warning: libQtXlsx.so, needed by /home/doug/Downloads/PyQt5Rpt/qtrpt-code_git/QtRptDesigner/../bin/debug/lib/libQtRPT.so, not found (try using -rpath or -rpath-link) make[1]: Leaving directory '/home/doug/Downloads/PyQt5Rpt/build-QtRptProject-Desktop-Debug/QtRptDesigner' /usr/bin/ld: /home/doug/Downloads/PyQt5Rpt/qtrpt-code_git/QtRptDesigner/../bin/debug/lib/libQtRPT.so:...
-
Thanks for another helpful reply. You do give excellent support!
-
Once I worked out what I was doing, it all went fine until Qt Creator reached this point: ../../qtrpt-code_git/CommonFiles/XYZ_TextEditor.cpp: In constructor ‘XYZTextEditor::XYZTextEditor(QWidget*)’: ../../qtrpt-code_git/CommonFiles/XYZ_TextEditor.cpp:39:42: error: invalid use of incomplete type ‘class QButtonGroup’ auto btnGroup = new QButtonGroup(this); ^ In file included from /usr/include/qt5/QtWidgets/qtoolbutton.h:45, from /usr/include/qt5/QtWidgets/QToolButton:1, from tmp-lin64/ui_XYZ_TextEditor.h:20,...
-
Perfect. Thanks fpr pointing me in the right direction. I will get to grips with all this and hope I don't need to bother you again for a while. "8-) Doug
-
On my platform, Qt Creator does not have a 'settings' menu and the help returns no hits on 'profiles'. 'Help About' reports 'Qt Creator 4.7.2 Based on Qt 5.11.3' - does that sound right?
-
Ah - that will be the problem. I tried 'dnf remove qt4*' and the system wanted to delete nearly a gigabyte of current applications I use! Now I have to ask what you mean by 'Qt profiles'?
-
Thanks for the prompt reply, aliks-os. It is great to know it will run on my platform - I am excited to get this project running. My Qt5 Designer reports 'Qt version 5.11.1', but 'pkg-config --modversion QtCore' reports '4.8.7'. I must have an old Qt4 lying around somewhere! Drat. More investigation required. Everything I design in Qt5 Designer and further develop in Python 3.7.2 runs happily, so I am not sure exactly what is going on. I will get under the hood and see what I can find. A search turned...
-
Excellent project. I have been wishing for this for a very long time and just found it yesterday I am hoping to build the project for Linux, but have encountered my first major problem. In the file 'qtrpt-code_git/3rdparty/QtXlsx/xlsxglobal.h' there is an inclusion '#include <qtglobal>', but I cannot work out which QtGlobal you are referring to. What am I missing? Will I even be able to build this under Linux - that is, is there any hardcoded reference only relevant to Windows?</qtglobal> Thanks...
-
VOTE: scribus
-
I have a particlar need to import text created in a particular font (from Inkscape...
-
I have a particlar need to import text created in a particular font (from Inkscape...
-
I have searched here and through Google for this problem, but have no hits. When...
-
Thank you, Otto. It looks as though installing 2.9 beta 2 might be my best course...
-
"If you start the DVD with a First Domain Command you need to untick "Start directly...
-
"If you start the DVD with a First Domain Command you need to untick "Start directly...
-
Fedora Linux 21, on a Lenovo Z61t laptop. 3Gb RAM, 3 Gb swap, 30Gb free disk space....
1