| View previous topic :: View next topic |
| Author |
Message |
Jim Reiley Guest
|
Posted: Tue Jan 23, 2007 12:19 am Post subject: Table Filter |
|
|
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. |
|
| Back to top |
|
 |
Wayne Niddery [TeamB] Guest
|
Posted: Tue Jan 23, 2007 4:30 am Post subject: Re: Table Filter |
|
|
Jim Reiley wrote:
| 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 |
|
| Back to top |
|
 |
|