I need to filter a table so i can display the correct records. The problem is that I have about 3 or 4 critera's to meet but I keep getting an error when trying to complile.
The code I am using
Tab is a variable defined before the filter is set.
tbapptsearch.Filter := 'chiropractor_id =' + inttostr(tab)
and 'status = ' + quotedstr('pending');
The error I get points to the 2nd +.
[Error] datamod2.pas(187): Operator not applicable to this operand type.
Now if I do it like this.
tbapptsearch.Filter := ('chiropractor_id =' + inttostr(tab))
and ('status = ' + quotedstr('pending'));
I get the same error but it points to the ;.
My usuall style of trial and error codeing is failing me at this point.