ADOTable Filter

[MLNorton]

I have an ADOTable with multible fields. I need to filter on two fields, PayFor and PayYear, both string values. The filter values are:
PayFor = Reunion
PayYear = 2012

The following code does not work:

var
s: string;
t: string;
begin
With Form_Main.ADOTable5 do
begin
s := 'Reunion';
t := '2012';
Filter := 'PayFor = ' + QuotedStr(s) and PayYear = ' + QuotedStr(t);
Filtered := true;

 

[majlumbo]

Don't know if it's a typo, but the filter should be:

Filter   := 'PayFor = ' + QuotedStr(s)+' and PayYear = ' + QuotedStr(t);

 

[Prattaratt]

Whenever I have problems with a SQL string, what I will do is build the string into a String variable before assigning the value of the variable to the SQL command or Filter. That way I can examine what exactly is being passed to the DB. Once I have the problem solved I will streamline the assignment directly to the property involved.
And Majlumbo is correct about the error in your filter statement.

 

[MLNorton]

Problem solved. Thanks