Implementing SELECT DISTINCT in a TPS Database

By Jon Waterhouse

Posted January 9 2001

Summary: In SQL when you want a report showing only single instances of a particular data element you can use the SELECT DISTINCT statement. But what do you do when you want this same capability in a TPS database? Jon Waterhouse presents a template that does the job.

Please log on to read this subscriber-only article. If you do not have a subscription you can purchase one in the ClarionMag store.

Clarion Roadmap

Try the roadmap (beta)

Search ClarionMag

 

Advanced search

From the archives

External Business Rules with the In-Memory Driver

6/21/2006 12:00:00 AM

Towards the end of 2004 Nardus Swanevelder wrote a series of articles on Clarion's Business rules, and how they could be configured at runtime. In this update, Nardus shows how to use configurable business rules with the In-Memory Driver. SOURCE LINK UPDATED!