SQL Tips and Tricks
Posted December 23 2009
Summary: Joe Tailleur shares some of his SQL tips and techniques, including field naming, dummy tables, speeding up reports, self-joins, and more.
Please log on to read this subscriber-only article. If you do not have a subscription you can purchase one in the ClarionMag store.
Search ClarionMag
From the archives
Compiled Reports From Report Writer
3/29/2004 12:00:00 AM
As far as Henry Plotkin is concerned, the best thing about Clarion Report Writer is the ability to set up the finished page without having to adjust the position of each individual band. The next best thing about Report Writer is that report testing is much faster. It does not require a compile-link cycle. It does not require minimizing Clarion, starting the application and navigating to the report. Wouldn't it be nice to be able to design reports in Report Writer, and then just copy them into a Clarion report procedure? Actually, it can be done, and fairly easily.