Board index » delphi » More than one filter condition from varibles

2004-02-07 07:47:47 PM
delphi27
Mytable.filter := 'date=' datepicker.date and 'state=' edit1.txt
How do I do this?
Must I use the onfilter routine or can I use just the filter property?
Carlos
 

Carlos writes:
'and' needs to be part of the string). Try:
Mytable.filter := 'date=' QuotedStr(FormatDateTime('mm/dd/yy',
datepicker.date)
+ ' and state=' QuotedStr(edit1.txt);
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: www.logicfundamentals.com/RADBooks.html
"It is error alone which needs the support of government. Truth can
stand by itself." - Thomas Jefferson
 

Thanks
Carlos