Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 21 to 28 of 28 total |
Possible bug using fully qualified references |
Mon, May 14 2007 5:37 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
I hit <Enter> too quickly, but my response was basically complete. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, May 15 2007 3:44 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
I do that as well Roy Lambert |
Wed, May 16 2007 11:27 AM | Permanent Link |
Chris Erdal | Roy Lambert <roy.lambert@skynet.co.uk> wrote in
news:0091AF6E-5FA6-4FCA-804D-3DF91BA5E440@news.elevatesoft.com: > > As I said LIKE isn't a direct comparison for CONTAINS eg > > CONTAINS 'fred bert joe' > > would have to become > > LIKE '%fred%' AND LIKE '%bert%' AND LIKE '%joe' > > which would return true for 'frederica bert joe' which is wrong. > > It means I'll need to write my own function to do it. Any hints or > suggestions (especially code) gratefully received. > Roy, I've done this in C (some time ago - like several decades ago and I used something like WHERE ' '+<myField>+' ' LIKE '% fred %' AND ' '+<myField>+' ' LIKE '% bert %' AND ' '+<myField>+' ' LIKE '% joe %' if that helps any. I built up the WHERE clause in a loop depending on the number of words and it worked OK. -- Chris (XP-Pro + Delphi 7 Architect + DBISAM 4.25 build 4 + EDB 1.02 build 1) |
Wed, May 16 2007 1:14 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Chris
> I've done this in C (some time ago - like several decades ago and I >used something like > >WHERE ' '+<myField>+' ' LIKE '% fred %' >AND ' '+<myField>+' ' LIKE '% bert %' >AND ' '+<myField>+' ' LIKE '% joe %' > >if that helps any. Unfortunately no. The problem comes when the word separator is not a space (eg .,!? etc). I'll have to create my own word list and test it. The only "problem" is for generating the code I need to have two ways of doing the same thing, one for indexed columns and one for non-indexed columns - ok for typing in but makes it messier for auto generating the sql and now with the latest bombshell that filters will not support UDF's impossible unless I use queries. Roy Lambert |
Wed, May 16 2007 1:25 PM | Permanent Link |
Chris Erdal | Roy Lambert <roy.lambert@skynet.co.uk> wrote in
news:A5B93C85-996F-410B-9E8B-B2B890296CC6@news.elevatesoft.com: >>if that helps any. > > Unfortunately no. The problem comes when the word separator is not a > space (eg .,!? etc). Ah, yes, I remember now. This was for finding keywords in a field filled in by program from user data, so the SPACE separator was guaranteed in my case. But it's certainly a good idea to be able to filter on a non-indexed memo or text field in a small subset of a huge table, when necessary. So once you've got it working, perhaps Tim'll accept it for the "Extended EDB Function Library" he's not yet mentioned EDB will soon have -- Chris (XP-Pro + Delphi 7 Architect + DBISAM 4.25 build 4 + EDB 1.02 build 1) |
Wed, May 16 2007 2:21 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Chris
Or even better he'll take pity on us poor users <vbg> Roy Lambert |
Thu, May 17 2007 1:45 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Or even better he'll take pity on us poor users <vbg> >> Unfortunately I couldn't change it now if I wanted to. The text indexing parameters are intriniscally tied to the text indexes themselves, and modifying that is not really an option. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, May 17 2007 2:42 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>Unfortunately I couldn't change it now if I wanted to. The text indexing >parameters are intriniscally tied to the text indexes themselves, and >modifying that is not really an option. I know - but I always was an unjustified optimist Roy Lambert |
« Previous Page | Page 3 of 3 | |
Jump to Page: 1 2 3 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |