` Printed Icetips Article

Icetips Article

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'

Printed April 28, 2024, 4:54 pm
This article has been viewed/printed 35115 times.
Google search has resulted in 71 hits on this article since January 25, 2004.