Re: TADODataSet Filter


Trying to filter a ADODataSet I get an error message when using an OR in
the filter. The message is EOleException, Arguments are of the wrong
type, are out of acceptable range or are in conflict with one another.

This one works find
Filter := '(Compagnie = 'ELECTRO-OPTICAL INC.') AND ([Prêt à exp R] > 0)
'

This one does not
Filter := '(Compagnie = 'ELECTRO-OPTICAL INC.') AND ((Prêt à exp R] > 0)
OR ([Prêt à exp] > 0))'

You have to write it like this for the filter to process

Filter := '((Compagnie = 'ELECTRO-OPTICAL INC.') AND (Prêt à exp R] > 0) )
OR ((Compagnie = 'ELECTRO-OPTICAL INC.') AND ([Prêt à exp] > 0))'


--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Origin of hoomu
    ... > Just add the other name to your filter. ... And thanks for not seeking a conflict. ... But more precisely, you were not disagreeing with me, ...
    (sci.lang.japan)
  • Re: resistance readings
    ... How about fuel pressure or filter or a blocked cat,more likely than the ... > acceptable range. ... However, when measured through the pigtail, idle is ...
    (rec.autos.tech)
  • Re: A conflict issue, or something else...?
    ... 'Treat changes to the same column as a conflict is selected' shouldn't make ... I'd guess it's either a filter issue or a conflict, ... selected resolver and one subscriber it's difficult to see. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Replacing a Whole House Water Filter Way too Frequently
    ... I'm very well aware of the conflict of interest. ... actually suggested to pursue investigating the well first, ... filter hasn't become clogged at all, but the water is extremely cloudy. ... The water is being tested by a different lab even as we speak. ...
    (alt.home.repair)
  • Re: TADODataSet Filter
    ... Serge Myrand wrote: ... Trying to filter a ADODataSet I get an error message when using an OR ... The message is EOleException, Arguments are of the ...
    (borland.public.delphi.database.ado)