Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 Manual for C++Builder 6 » Using ElevateDB » Setting Filters on Tables, Views, and Query Result Sets |
Difference | Description |
Correlation Names | You cannot use table or column correlation names in filter expressions. |
Query expressions | You cannot use query expressions in filter expressions. |
Wildcards | You can additionally use the asterisk (*) wildcard character with the equality operator (=) or inequality operator (<>) in order to perform partial-length comparisons. However, this only works when the foNoPartialCompare element is not included in the FilterOptions property. |
{ // Set the filter expression MyTable->Filter="(LastSaleDate >= DATE "+Engine->QuotedSQLStr("1998-01-01")+") "+ "and (LastSaleDate <= DATE "+Engine->QuotedSQLStr("1998-12-31")+") "+ "and (TotalSales > 10000)'; TFilterOptions FilterOptions; FilterOptions->Clear(); MyTable->FilterOptions=FilterOptions; MyTable->Filtered=true; }
void __fastcall TMyForm::TableFilterRow(TDataSet *DataSet, bool &Accept); { Accept=false; if (Pos("Hardware", DataSet->ColumnByName("CustomerName")->AsString) > 0)) { Accept=true; } }
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |