Jan 13, 2011 #1 MLNorton Programmer Joined Nov 15, 2009 Messages 134 Location US This filder does nor work. What is the solution? ADOTable1.Filter := ('MemLetter <> ' + quotedStr('-')) and ('MemLetter <> ' + quotedStr('Sent'));
This filder does nor work. What is the solution? ADOTable1.Filter := ('MemLetter <> ' + quotedStr('-')) and ('MemLetter <> ' + quotedStr('Sent'));
Jan 13, 2011 #2 Griffyn Programmer Joined Jul 11, 2002 Messages 1,077 Location AU The Filter property is a string. The expression you've got here results in a Boolean. Try instead Code: ADOTable1.Filter := '(MemLetter<>' + QuotedStr('-') + ') and (MemLetter<>' + QuotedStr('Sent') + ')'; or to make it easier to read IMO: Code: ADOTable1.Filter := '(MemLetter<>''-'') and (MemLetter <>''Sent'')'; Upvote 0 Downvote
The Filter property is a string. The expression you've got here results in a Boolean. Try instead Code: ADOTable1.Filter := '(MemLetter<>' + QuotedStr('-') + ') and (MemLetter<>' + QuotedStr('Sent') + ')'; or to make it easier to read IMO: Code: ADOTable1.Filter := '(MemLetter<>''-'') and (MemLetter <>''Sent'')';