ADODataset.Filter question.

From: JP (news_at_frieltek.com)
Date: 01/25/05 

Date: Tue, 25 Jan 2005 14:46:14 -0600

I'm trying to apply a filter of:

(Desc1 like '%4%' or AcctNo like '%4%' or Sku like '%4%') and MatchCode =
'A'

to an ADODataset but I am getting:

( X ) Arguments are of the wrong type, are out of acceptable range, or are
in conflict with one another.

If I remove the end << and MatchCode = 'A' >> it works fine. If I use just
<< Matchcode = 'A' >> it will filter the A records correctly. But I cannot
figure out why I cannot filter on both MatchCode and the other text fields
together!

I even tried putting matchcode in parens << and (MatchCode = 'A') but that
failed the same way.

Using Delphi 6, all the patches and going against a Microsoft SqlServer 7.0.

John

Relevant Pages

  • Re: Database Filter question
    ... > I use ADO to connect to an SQL Database. ... I use an ADODataSet to hold a ... > When I set the Filtered property to True (ADODataset1.Filtered:= ... > will it automatically Execute its CommandText and then filter the new ...
    (borland.public.delphi.database.ado)
  • Re: Database Filter question
    ... > Allan Nielsen wrote: ... >> I use ADO to connect to an SQL Database. ... I use an ADODataSet to hold a ... >> will it automatically Execute its CommandText and then filter the new ...
    (borland.public.delphi.database.ado)
  • Re: Database Filter question
    ... I use an ADODataSet to hold a ... >complete recordset from a select query. ... >automatically Execute its CommandText and then filter the new resultset? ...
    (borland.public.delphi.database.ado)
  • Database Filter question
    ... I use ADO to connect to an SQL Database. ... I use an ADODataSet to hold a ... complete recordset from a select query. ... automatically Execute its CommandText and then filter the new resultset? ...
    (borland.public.delphi.database.ado)
  • Re: reports
    ... "John" wrote: ... down the essence of a plan into a single metric - it can be so ... or some similar classical schedule analysis approach. ... In the Filter Definition window, ...
    (microsoft.public.project)