ÿþ<Html> <CET_ADSENSEH> <script type="text/javascript"><!-- google_ad_client = "pub-5291624188982543"; /* 728x90, A>740=> 04.02.08 */ google_ad_slot = "9704471239"; google_ad_width = 728; google_ad_height = 90; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> </CET_ADSENSEH> <CET_HEADER> <table width="100%" border="0"> <tr> <td width="220"><a href="http://www.chmlib.com"><img src="http://www.chmlib.com/chmlib_logo.gif" alt="CHMlib Logo" width="220" height="93" border="0"></a></td> <td width="240"><div align="center"><span class="style6"><B><a href="http://www.chmlib.com">Free Online Library Of Help Files</a></B><a href="http://www.chmlib.com"><B>.<br> Read help files in convenient way.</B></a></span></div></td><td ><a href="http://www.projetex.com/">Leading Translation Management System for Translation Agencies</a>, <a href="http://www.to3000.com/">Top Translation Management Software for Freelance Translators</a>, <a href="http://www.exactspent.com/">Time Tracking Software</a>, <a href="http://www.anycount.com/">Word Count, Character Count and Line Count Software</a>, <a href="http://www.catcount.com/">Computer Assisted Translation Tool for Easy Word Count</a>, <a href="http://www.clipcount.com/">Clipboard Character Count Software</a>, <a href="http://www.anymem.com/">User-Friendly Translation Memory Software</a>, <a href="http://www.anylexic.com/">Terminology Management Software</a>, <a href="http://www.anylexic.com/Terminology-Management-Software-Server-Features.html">Terminology Management Server</a>, <a href="http://www.winlexic.com/">Microsoft Glossary Software</a>, <a href="http://www.acrolexic.com/">Dictionary of Acronyms</a>, <a href="http://www.langmates.com/">Social Network for Translators and Translation Agencies</a>, <a href="http://www.acronymia.com/">Acronyms and Abbreviations Search Engine</a>, <a href="http://www.translation3000.com/Translation/Russian_Translation.html">Russian Translation Lab</a>, <a href="http://www.translation3000.com/Translation/Ukrainian_Translation.html">Ukrainian Translation Lab</a>.</td></tr></td> </tr> </table> <table width="100%" border="0"> <tr> <td colspan="2" bgcolor="#0099FF"><div align="right" class="style1"> <div align="center"><font color="#FFFFFF">You are reading help file online using chmlib.com</font></div> </div></td> </tr> </table> </CET_HEADER> <Head></Head><Title>TPSCCustomFltBld</Title><Body><font face="Arial"><font SIZE="2"> <P Align="left"> <font SIZE="3"><B>TPSCCustomFltBld.SQL</B></font><BR> <A href="TPSCCustomFltBld.html">TPSCCustomFltBld</A>&nbsp&nbsp&nbsp&nbsp&nbsp</P>Contains valid SQL which can be used to query data.<BR> <BR> <B>property</B> SQL: TStrings;<BR> <BR> <font SIZE="2"><B>Unit</B></font><BR> <A href="psc_fltbox.html">psc_fltbox</A><BR> <BR> <font SIZE="2"><B>Description</B></font><BR> Use SQL property to retrieve a valid SQL with modified WHERE clause (depending on the Items property) and modified ORDER BY clause (depending on the OrderByItems property). SQL property doesn't store anything, it's a calculated property. When component generates SQL property it takes text from the SQLHead property (SQLHead contains static query part), adds there WHERE clause (if needed, depend on WhereInc property), adds there filter conditions if any (FilterStr property), add there text from SQLTail property, adds there ORDER By clause (specified in OrderByItems) and adds there text from SQLOBTail (states for "sql order by tail") property. SQL property is readonly, so if you want to change it, you need to change properties listed above. SQL property is not stored to disk when form, which contains the component is stored. If HookSQLProp is True, than SQL property will be automatically assigned to DataSet's SQL property each time it's changed due to change in it's parts.<BR> <BR> <font SIZE="2"><B>See also:</B></font><BR> <A href="TPSCCustomFltBld.FilterStr.html">FilterStr</A>, <A href="TPSCCustomFltBld.Items.html">Items</A>, <A href="TPSCCustomFltBld.OrderByItems.html">OrderByItems</A>, <A href="TPSCCustomFltBld.SQLHead.html">SQLHead</A>, <A href="TPSCCustomFltBld.SQLOBTail.html">SQLOBTail</A>, <A href="TPSCCustomFltBld.SQLTail.html">SQLTail</A>, <A href="TPSCCustomFltBld.WhereInc.html">WhereInc</A><BR> <BR> <HR> <font SIZE="1">Generated by Putersoft.FreeHelp. Copyright © 1999-2002. <A href="http://www.putersoft.com" target="_blank">puterSoft.Com</A></font></font></font> <CET_ADSENSEF> <script type="text/javascript"><!-- google_ad_client = "pub-5291624188982543"; /* 728x90, A>740=> 04.02.08 */ google_ad_slot = "9704471239"; google_ad_width = 728; google_ad_height = 90; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> </CET_ADSENSEF> <CET_FOOTER> <table width="100%" border="0"> <tr> <td colspan="2" bgcolor="#0099FF"><div align="right" class="style1"> <div align="center"><font color="#FFFFFF">You are reading help file online using chmlib.com</font></div> </div></td> </tr> </table> <hr align="left" width="650"><BR> If you want your help file to be removed or added please send e-mail to chmlibcom@gmail.com </CET_FOOTER> </Body></Html>