Tank you too!A moment ago I tried, and in fact I got a report based on all records in the table - looking away from it was not much sense in it. When I get to the point filling the report with text and numbers I may get what I want. I speculated about the query, using it for producing a report. It is a bit of time (some years) since I used sql, but since my report is only a "picture" of the records in the table I could not see how to use sql for the report. You gave me the right answer. (When I have got a meaningful report, next step is to convert the .ps file to something useful for my printer, possibly ps2pdf).
I was in fact looking at the /var/lib/mysql directory, presented as empty by Dolphin. Sorry, I didn't see that Dolphin was not able to open the directory. So my table(s) may be inside there. Why mysqldump did give me an empty .sql file (as presented in Dolphin) is not clear to me yet, but I may find a reason ...
Thank you for the tip on using Nssbackup instead of mysqldump and copying hk-classes myself! I will install it as soon as possible to get my database moved to my laptop in an easy way.
And again to you helpful people: Thank you for your efforts to educate me! When I get some more experience, may be Knoda is not so bad for making reports :-) .
Nils M. Nielsen Robert Leleu skrev:
As a complement to R Wood responseHave a report based on a table, activate it (the blue gear) and you get the populated reportHave a report based on a query .......I use mysql on my machine: the base data ara stored according to mysql custom in /var/lib/mysqlIn ~/.hk_classes are the files describing Knoda objects. So I gave these paths to my NssbackupJe la 19/03/2010 13:16-------- Origina mesag^o-------- Nils M. Nielsen skribis (esperanto estas la unua internacia lingvo):Thank you, Robert Wood, for your helpful advice. Now I may be able to get something on my report, though I feel there are a lot of questions left to figure out. I tried this ... button after point-and-click in the data section. Something went wrong, I got no field box in there, but in the section before. Well, at least I got a picture of what it looked like, so I could select the box in the menu line and put it in, so select the table column and get the box filled into the data section layout. (Possibly I should have stayed with Free Pascall and Lazarus - but there I got problems with a broken installation on Kubuntu.). May be I have to install the source and have a look at it to see what is going on behind the scenes. There was no problem at all to design the input form I needed, with (read only) images and all, for that part everything felt natural and the tutorial was understandable, but the report handling part does not match the forms part.Also, I have not figured out yet how to get the report processing all my records without some form of programming/scripting. I have no experience from using this type of software. Though Knoda is a clever bit of software, it seems not to be designed for the end user needing a way of presenting av report from her/his data in a reasonable easy way.Another problem is that Knoda has no backup facility. I resorted to mysqldump, and got an empty .sql file. As usual: dirt in dirt out, no error message. Knoda had placed my database etc. in directory hk-classes under my home directory. So to move the database to another PC I hopefully get everything I need by copying the hk-classes directory with subdirectories on to an usb stick to install on the other PC. That should not be the way of doing it I think.Nils M. Nielsen Robert Wood skrev:>> My befuddled memory indicates that %VALUE% is the contents of the query/table box that you have selected. << That would make sense, yes.>> My very clear memories of the handbook is that it is annoyingly complete and comprehensive. On the odd occasion that I queried it with Hans Knoda it was all due to my dyslexia. After being admonished more than once I began to realise how complete it is and how it says so much with so few words. <<I think that indicates it was written by an engineer for people who are similar minded! This is not always the best style for newbs and less experienced software people. :~)>> Like most other people on this list I am looking for an alternative programme. I like the ability to add pictures to your forms and the whole concept of generating forms on a clean sheet of paper without any 'factory made' boxes. Whilst Access may be functional it is inhuman, Open Office Base needs code before it will do all of the tricks that Knoda will do. <<I tried kexi as well as OO Base and found them poor compared to knoda which was *relatively* easy to pick up. (OO Base is abysmal.) I wouldn't use anything Microsoft wrote even if you paid me. ;~)I am lead to believe kexi has really improved. the last time I looked, there was nothing in my KDE4 repository, and it was still very much in beta which is why I knocked up my own system. It's a lot easier to do a custom one than a generic version it would seem!BTW, I wrote: "Right click on the section and then on the ... button to the right of the datasources combo." I did, of course, mean left click. Sorry about that.------------------------------------------------------------------------------Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Hk-classes-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Hk-classes-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss------------------------------------------------------------------------ ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ------------------------------------------------------------------------ _______________________________________________ Hk-classes-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
<<attachment: niniel.vcf>>
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev
_______________________________________________ Hk-classes-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
