Re: Can't use '*' in TADODataset.Filter
- From: "Arjan de Haan" <2x nospam nospam adwhaan AT hotpop.com>
- Date: Tue, 22 Aug 2006 08:13:32 +0200
"Thammarat charoenchai." <apatiu@xxxxxxxxx> wrote in message
news:44ea6e50@xxxxxxxxxxxxxxxxxxxxxxxxx
tblProduct.Filter := 'Name=''*' + edName.Text + '*''';
tblProduct.Filtered := True;
it's not work.
Not sure what you mean with 'it's not work' but I'm assuming you don't see ANY records
after turning on the filter. That's because you are filtering on a literal value (say
'*Jon*') instead of what I think you want: any value containing the searched value (like
'John Jones').
Because you're using wildcards, you need to use LIKE instead of =, like so:
tblProduct.Filter := 'Name LIKE ''*' + edName.Text + '*''';
tblProduct.Filtered := True;
Hope this helps.
Success.
....Arjan...
.
- Follow-Ups:
- Re: Can't use '*' in TADODataset.Filter
- From: Brian Hollister
- Re: Can't use '*' in TADODataset.Filter
- References:
- Can't use '*' in TADODataset.Filter
- From: Thammarat charoenchai.
- Can't use '*' in TADODataset.Filter
- Prev by Date: Can't use '*' in TADODataset.Filter
- Next by Date: Re: Can't use '*' in TADODataset.Filter
- Previous by thread: Can't use '*' in TADODataset.Filter
- Next by thread: Re: Can't use '*' in TADODataset.Filter
- Index(es):
Relevant Pages
|
