Board index » delphi » Table Filter

Table Filter


2007-01-23 02:19:50 AM
delphi94
The filter on a table below process's correctly upto the 'or' part of
the statement. This part it doesn't process at all.
Form1.tbAdStar.Filter := 'InternetAvailable <>' + QuotedStr('Y') + 'or
Inactive = ' + QuotedStr('Y');
What seems to be wrong here?
Thanks.
 
 

Re:Table Filter

Jim Reiley writes:
Quote
The filter on a table below process's correctly upto the 'or' part of
the statement. This part it doesn't process at all.

Form1.tbAdStar.Filter := 'InternetAvailable <>' + QuotedStr('Y') +
'or Inactive = ' + QuotedStr('Y');
Try putting parenthesis around each condition:
Form1.tbAdStar.Filter := '(InternetAvailable <>' + QuotedStr('Y') +
') or (Inactive = ' + QuotedStr('Y') + ')';
--
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"In a tornado, even turkeys can fly." - unknown