Roy,

I hit  <Enter> too quickly,  but my response was basically complete.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


I do that as well

Roy Lambert

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)

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

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)

Chris


Or even better he'll take pity on us poor users <vbg>

Roy Lambert

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

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