Quartam Software Forums

Although Quartam PDF Library is a free/open source software (F/OSS) project, giving you a lot of freedom and flexibility as to how you use it in your own projects, this doesn't mean you're free to do anything you want with it: you have to respect the GNU Affero General Public License (AGPL) version ...

And we're off - Quartam PDF Library is now a free / open source project and just hit version 1.1. I hope to see you on board as a contributor!

Jan Schenkel.

Today, Quartam Software is proud to announce the release of Quartam PDF Library for LiveCode version 1.1, as open source under a dual license. Quartam PDF Library allows LiveCode developers to go beyond 'print to pdf file' as it offers pin-point control, extensive graphics support and much more. Whe...

Next week I'll be at the RunRevLive.11 conference in sunny San Jose, California, giving two presentations: Advanced Databases and Extending LiveCode with Java. Here is a brief description for both sessions. -- Advanced databases: You've just finished a desktop application that stores its data in a l...

Well, it's actually not that strange - the data context has already moved on to the next record. This is easier to get right when scripting your own custom data broker. Admittedly, this is something that should be handled more elgantly, by pushing the context back before printing the group footers, ...

Quartam PDF Library was not abandoned. An important announcement concerning its future will be made this month.

Jan Schenkel.

Hi Josep, As it is the day-job that pays the bills, I have to give that precedence. And that's why I prefer not to communicate release dates until I have a feature-complete and fairly stable build. The only thing I'm willing to say at this point, is that there will be a version 1.2 in the first half...

Well, if you have two SELECT statements that you're going to combine using UNION, your life will be a lot easier if you give the columns a common name. SELECT 1 AS ReportSection, PartDescription AS Description, NumberSold, UnitPrice, NumberSold * UnitPrice AS LineTotal FROM ... UNION ALL SELECT 2 AS...

One more suggestion - when you go down the 'SELECT UNION SELECT' route, you should use 'AS' frazes to give each column the same name across the different 'SELECT' statements.

Jan Schenkel.

Hi Igal, This one is a bit of a challenge, but not impossible to accomplish. I would fetch all the data in a single query, using UNION to put together different SELECT results as part of each SELECT, I would add a 'ReportSection' column with a fixed value that way I could use the 'qrtReports_PrintRe...