Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 Manual for Lazarus 2.00 (Win32) » 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. |
begin with MyTable do begin { Set the filter expression } Filter:='(LastSaleDate >= DATE '+Engine.QuotedSQLStr('1998-01-01')+') '+ 'and (LastSaleDate <= DATE '+Engine.QuotedSQLStr('1998-12-31')+') '+ 'and (TotalSales > 10000)'; FilterOptions:=[]; Filtered:=True; end; end;
procedure TMyForm.TableFilterRow(DataSet: TDataSet; var Accept: Boolean); begin Accept:=False; if Pos('Hardware', DataSet.ColumnByName('CustomerName').AsString) > 0) then Accept:=True; end;
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 |