Filter statement for filtering multiple fields
Posted: Sat 08 Feb 2020 01:54
Hi
I can't figure out whats the correct syntax for filtering on multiple fields.
for 1 field i use :
dmCrew.Contact.Filter:='Status='+QuotedStr('Active');
for 2 fields i tried:
dmCrew.Contact.Filter:='Status='+QuotedStr('Active')+' AND '+'LastName='+QuotedStr('Mierlo');
I can't figure out whats the correct syntax for filtering on multiple fields.
for 1 field i use :
dmCrew.Contact.Filter:='Status='+QuotedStr('Active');
for 2 fields i tried:
dmCrew.Contact.Filter:='Status='+QuotedStr('Active')+' AND '+'LastName='+QuotedStr('Mierlo');