I did some further tests on that and it seems that there is a problem
with the combination of "like" and "contains".

I changed all indexes to TextIndex.

This query using "contains" works fine:

select  Caption, Search, Text from Folders where
(
Caption contains '*steuer*'
or Search contains '*steuer*'
or text contains '*steuer*'
)
AND
(
Caption contains '*ident*'
or Search contains '*ident*'
or text contains '*ident*'
)

while this one mixing "like" and "contains" fails:

select  Caption, Search, Text from Folders where
(
Caption like '%steuer%'
or Search contains '*steuer*'
or text contains '*steuer*'
)
AND
(
Caption like '%ident%'
or Search contains '*ident*'
or text contains '*ident*'
)

The latter doesn't find the record with 'steuer' and 'ident' in the
field "Caption".

Uli

Uli Becker wrote:

> I did some further tests on that and it seems that there is a problem
> with the combination of "like" and "contains".
>
> I changed all indexes to TextIndex.
>
> This query using "contains" works fine:
>
> select  Caption, Search, Text from Folders where
> (
> Caption contains '*steuer*'
> or Search contains '*steuer*'
> or text contains '*steuer*'
> )
> AND
> (
> Caption contains '*ident*'
> or Search contains '*ident*'
> or text contains '*ident*'
> )
>
> while this one mixing "like" and "contains" fails:
>
> select  Caption, Search, Text from Folders where
> (
> Caption like '%steuer%'
> or Search contains '*steuer*'
> or text contains '*steuer*'
> )
> AND
> (
> Caption like '%ident%'
> or Search contains '*ident*'
> or text contains '*ident*'
> )
>
> The latter doesn't find the record with 'steuer' and 'ident' in the
> field "Caption".
>
> Uli

Uli,

Thanks for following up.

--
Michael Riley
GySgt USMC (Ret)
www.zilchworks.com

Uli


Have you sent a test case to Tim so he can fix it?

Roy Lambert

Roy,

<<Have you sent a test case to Tim so he can fix it?>>

not yet, but I'll do that soon.

Uli

Uli,

<< not yet, but I'll do that soon. >>

Please do - I'm getting ready to do a new build in the next week, and I'm
only averaging about a new build every month.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com