Robert Wood wrote: > I can't remember what %VALUE% is for, I just have it in all the fields > in the datasection of my reports. > > You set up the fields by assigning a table to the section you're setting > up. Right click on the section and then on the ... button to the right > of the datasources combo. Select what you want there and you can have > access to the particular query you previously set up and assign the > returned query values it to any of the fields you put in the section > once you click on the field. > > Hope that makes sense and that's what you're after. > > I think it's fair to say the forms are one of the more difficult parts > of knoda. > > > > On 18/03/10 14:49, Nils M. Nielsen wrote: > >> My problem is in fact the construction of the report. The tutorial shows >> a finalized report, but not how to set up the fields etc. I have got to >> the point how to get the different sections "activated", but not to get >> the fields from my database put into the data section. I also not >> understand the meaning of the %VALUE% and other "functions". If he had >> placed some screen shots into the tutorial of the design process it >> would have been really helpful. >> >> Possibly I may get a problem with activation the final report to print 2 >> pages for each "record" in the database (about 700 records :-) ), but ... >> >> Thank you in advance if you could give me some hints. >> >> Sincerely Nils M. Nielsen >> >> Robert Leleu skrev: >> >>> Indeed the tutorial is not easily understandable.... >>> however I succeeded to set up 2 reports. >>> >>> What is your problem? The construction (set up) of a report? or how to >>> call it from a window? >>> >>> >>> >>> Je la 17/03/2010 22:21-------- Origina mesaĝo-------- Nils M. Nielsen >>> skribis (esperanto estas la unua internacia lingvo): >>> >>>> May be I am a little bit out of topic. As a newbie with Mysql and >>>> Knoda I found it easy to set up Forms, though the handling of images >>>> was not impressive. Giving the path and the filename for the image, >>>> it should be straight forward to connect this two parts, look up and >>>> display the image. Now the user must do the loading manually. Also, I >>>> have not been able to figure out how to set up reports. The tutorial >>>> is hopeless to understand. Hopefully Kexi will handle reports in a >>>> reasonable way when it is brought a bit further. >>>> >>>> One another problem, was to handle SQL statements trough Knoda. I had >>>> to install Mysql Navigator to be able to do that without resorting to >>>> CLI programming at the terminal interface. >>>> >>>> Nils M. Nielsen >>>> >>>> Robert Leleu skrev: >>>> >>>>> Oh oh. I used some Python whithin Knoda, and the husband of one of >>>>> my daughters is a specialist in Python. So I'll definitely have a look. >>>>> >>>>> Je la 16/03/2010 22:21-------- Origina mesaĝo-------- Robert Wood >>>>> skribis (esperanto estas la unua internacia lingvo): >>>>> >>>>>> I must say, C++ is not an easy language, even having a fair deal of >>>>>> experience with C. mysql is not that difficult really for simple >>>>>> queries, and even inner joins start to make sense once you've done >>>>>> a few. >>>>>> >>>>>> You can program Qt (not QT, btw :~) ) in Python if you prefer. >>>>>> There are some good examples on you tube of basic programs. If you >>>>>> need any help with signals and slots just email me off list. >>>>>> >>>>>> On 16/03/10 21:02, Robert Leleu wrote: >>>>>> >>>>>>> For sure I'll stay tuned! >>>>>>> >>>>>>> I'll try to have a look at QT creator before the end of the year, but >>>>>>> since I don't know anything to sql and C++, it'll be just for >>>>>>> curiosity's sake. >>>>>>> >>>>>>> Have good luck! It'll be our good luck too! >>>>>>> >>>>>>> >>>>>>> Je la 16/03/2010 19:26-------- Origina mesaĝo-------- Robert Wood >>>>>>> skribis (esperanto estas la unua internacia lingvo): >>>>>>> >>>>>>>> Yes, I am just coming to the end of designing a database front >>>>>>>> end for >>>>>>>> my little company completely built on Qt creator/designer and >>>>>>>> written in >>>>>>>> C++ and mysql. >>>>>>>> >>>>>>>> With all the knowledge I have learned about Qt I hope to either >>>>>>>> make my >>>>>>>> own version of knoda or get knoda compiled under KDE4. >>>>>>>> >>>>>>>> It's actually made me learn a lot about mysql as well as C++. >>>>>>>> >>>>>>>> I intend to put knoda into creator and see how far I can get >>>>>>>> compiling >>>>>>>> it. (I tried a few months ago and got absolutely nowhere, but failed >>>>>>>> miserably.) >>>>>>>> >>>>>>>> I have done a little work in placing widgets on a form and >>>>>>>> allowing a >>>>>>>> user with no C++ or mysql knowledge to create their own system, >>>>>>>> but in >>>>>>>> the end decided I needed to do a custom one before I could really >>>>>>>> get my >>>>>>>> head round a knoda style system. >>>>>>>> >>>>>>>> Stay tuned. :p >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On 16/03/10 18:04, Robert Leleu wrote: >>>>>>>> >>>>>>>>> I recently installed Qt Creator, just because I needed it to >>>>>>>>> compile >>>>>>>>> subversion of Musescore, a music editor.... >>>>>>>>> and.... >>>>>>>>> Qt Creator was installed by Ubuntu in the same category as Knoda. >>>>>>>>> >>>>>>>>> So I had a look to it (just a first one), and saw it can create >>>>>>>>> "Widgets", and Windows, an I googled Qt creator with mysql, and saw >>>>>>>>> there is Mysql connection possible with Qt made softwares (and >>>>>>>>> other >>>>>>>>> database also), but it seems it's not without problems. >>>>>>>>> >>>>>>>>> Does any Knoda user investigated this Qt creator? >>>>>>>>> >>>>>>>>> Thanks >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> ------------------------------------------------------------------------------ >>>>>>>>> >>>>>>>>> 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 >>>>>>> >>>>>> ------------------------------------------------------------------------------ >>>>>> >>>>>> 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 >>>> >>> ------------------------------------------------------------------------ >>> >>> ------------------------------------------------------------------------------ >>> >>> 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 > My befuddled memory indicates that %VALUE% is the contents of the query/table box that you have selected. 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.
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 sincerely hope that your quest with Qt Creator will be fruitful. martin welsh ------------------------------------------------------------------------------ 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
