` Comment on an Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Add a comment to an Icetips Article

Please add your comments to this article. Please note that you must provide both a name and a valid email address in order for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!

Your Name:  
Email:  
Header text/Subject:  

Please enter your comment in the box below:
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 April 29, 2024, 1:36 am
This article has been viewed 35116 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