Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 10 of 14 total |
How to perform wildcard search using a Table? |
Mon, Jun 29 2009 12:57 PM | Permanent Link |
Brent | I've forgotten how to do a wildcard search using a table filter.
I've tried Filter := 'mymemo='''*Pepsi*'''; but that doesn't work because it returns no rows. It will find "Pepsi" using Filter := 'mymemo='''Pepsi*'''; only if mymemo starts with "Pepsi". So how can I search for a word or phrase that is inside a text or memo column using a table? TIA |
Mon, Jun 29 2009 1:14 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Brent,
<< I've forgotten how to do a wildcard search using a table filter. I've tried Filter := 'mymemo='''*Pepsi*'''; but that doesn't work because it returns no rows. >> Use the LIKE syntax instead: MyMemo LIKE '%Pepsi%' -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Jun 29 2009 1:14 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Brent
Just like in sql - use LIKE eg Filter := 'mymemo LIKE ''pepsi''' Roy Lambert [Team Elevate] |
Mon, Jun 29 2009 1:25 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Blast forgot the %s
Roy Lambert |
Mon, Jun 29 2009 2:54 PM | Permanent Link |
Brent | Roy Lambert wrote:
Blast forgot the %s Roy Lambert Roy & Tim, Ahh yes, the light went on. Is there any way to make this filter case insensitive? The CaseInsensitive option doesn't seem to do anything, at least not in DSU. Brent |
Mon, Jun 29 2009 4:22 PM | Permanent Link |
"Rita" | "Brent" <bdgridly@mailbolt.com> wrote in message news:C7AE383F-3467-4EFE-8B27-20F2112F975B@news.elevatesoft.com... > Is there any way to make this filter case insensitive? The CaseInsensitive > option doesn't > seem to do anything, at least not in DSU. > > FilterOptions := FilterOptions + [foCaseInsensitive]; Rita |
Mon, Jun 29 2009 6:00 PM | Permanent Link |
Brent | "Rita" wrote:
FilterOptions := FilterOptions + [foCaseInsensitive]; Hi Rita, That doesn't seem to work with a filter that is using "like". You can try it with the DBSU program, but it doesn't work there either. If you can get it to work there, let me know and I'll see if I can replicate it here. Brent |
Tue, Jun 30 2009 2:34 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Brent
Again think SQL UPPER(MyMemo) LIKE UPPER('%Pepsi%') Roy Lambert |
Tue, Jun 30 2009 4:20 PM | Permanent Link |
Brent | Roy Lambert wrote:
Brent Again think SQL UPPER(MyMemo) LIKE UPPER('%Pepsi%') Roy, Thanks. Do you know if these table filter functions are available in all table engines like BDE, Advantage, NexusDb etc.. or just DBISAM? Brent |
Wed, Jul 1 2009 2:49 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Brent
From memory definitely not in BDE other engines I can't say since I've been a DBISAM and now ElevateDB user since switching from the BDE. Roy Lambert |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |