` Using SQL filter on reports 2 (Geoff Bomford) - Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Icetips Article

Back to article list   Search Articles     Add Comment     Printer friendly     Direct link  

SQL Related Articles: Using SQL filter on reports 2
2004-03-30 -- Geoff Bomford
 
Newsgroups: softvelocity.public.clarion6 > > > I want to replace the SET with a PROP:SQL statement in front of the > report > > > process loop. The thing is, I'm not sure where the embed is for this. > > This Window.OpenReport before the parent call. Be careful with > Prop:SQL - > > an SQL filter is safer in this case. > Fogive me...I know SQL and Clarion, I'm just very green when it comes to > using them together. How/Where should I use a SQL filter in a report? Well, the first question is Why you want to use an sql filter Clarion does a pretty good job of converting a standard filter to the appropriate sql code - in most cases. As to how... In embed for ThisReport.ApplyFilter, before the parent call... Process:View{Prop:SQLFilter} = 'A.LastName LIKE <39>smith%<39>' ....will find all records where last name starts with 'smith'

Today is November 21, 2024, 3:53 am
This article has been viewed 35239 times.
Google search has resulted in 71 hits on this article since January 25, 2004.


Back to article list   Search Articles   Add Comment   Printer friendly

Login

User Name:

Password:


Gold Subscription
Buy Now
Silver Subscription
Buy Now
Solo Subscription
Buy Now
Multiple Copy Pricing
Renew Subscription