Roy,

<< However, I see "Text search on non-indexed columns" isn't available in
ElevateDB shame. I've found it a very useful feature.

I hope that the alternative isn't using lots of LIKE's >>

It's the same thing, essentially, except that LIKE is faster.  IOW, there is
no benefit to the full-text indexing without the "indexing" part.

--
Tim Young
Elevate Software
www.elevatesoft.com

<< - Firefox/2.0.0.2
- Windows XP Professional >>

I'm accessing it with FF 2.0.0.1 and it looks just fine.  I'll try it with
2.0.0.2, but I doubt if I'll see any difference.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< However, I see "Text search on non-indexed columns" isn't available in
>ElevateDB shame. I've found it a very useful feature.
>
>I hope that the alternative isn't using lots of LIKE's >>
>
>It's the same thing, essentially, except that LIKE is faster. IOW, there is
>no benefit to the full-text indexing without the "indexing" part.

But its a lot easier to generate a TEXTSEARCH for a wadge of words rather than to 1) determine wether or not this column has a text index and if not generate a load of LIKES.

Just being lazy again

Roy Lambert

Roy,

<< But its a lot easier to generate a TEXTSEARCH for a wadge of words rather
than to 1) determine wether or not this column has a text index and if not
generate a load of LIKES. >>

Actually, it's very simple.  Try using CONTAINS or DOES NOT CONTAIN on a
non-text-indexed column.  You'll get an error.

To be honest, this all goes back to the fact that the full-text searching in
EDB is more closely-tied to the parameters used to build the text index.  I
believe this was a step forward, even though the brute-force text searching
was lost in the process.  It's more flexible than the old text indexing in
DBISAM that was tied to the table instead of the index/column.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Actually, it's very simple. Try using CONTAINS or DOES NOT CONTAIN on a
>non-text-indexed column. You'll get an error.

What a wonderful way to do build a query from end user input. Can I tell them its your idea

Roy Lambert

Roy,

<< What a wonderful way to do build a query from end user input. Can I tell
them its your idea >>

Well, you shouldn't be allowing them to perform full-text searches on
columns that aren't indexed.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< What a wonderful way to do build a query from end user input. Can I tell
>them its your idea >>
>
>Well, you shouldn't be allowing them to perform full-text searches on
>columns that aren't indexed.

Oh yeah. Well in that case .... why did you build it in (score Roy 3 Tim 0)

Roy Lambert

Roy,

<< Oh yeah. Well in that case .... why did you build it in (score Roy 3 Tim
0) >>

Whoops, I just looked again and I forgot to put in the actual error when an
index doesn't exist.  Right now it simply returns all rows.

--
Tim Young
Elevate Software
www.elevatesoft.com