Tim

>1.07 has full wildcard support for CONTAINS like the LIKE operator. Meaning
>you can do this:
>
>MyColumn CONTAINS '*Test*'
>
>and it will still use the text index to optimize the search. It will be
>slower than just 'Test' or 'Test*', but much faster than actually accessing
>the indexed column directly to satisfy the search, especially with large
>CLOB columns.

You do realise that when I get 1.07 and function results are evaluated correctly I have to try and duplicate this for non text indexed columns don't you!

Roy Lambert

It is nice Roy thats the 2nd built with an Elevate software product
I liked on looks alone the 1st being Steve's KBase.
Dont the rest of you feel left out post some pics we can see.
Tim should give David and Steveo a million each.
My next offering will give everyone a £million in play money.
Kenneth has bought a VPS server for me he reckons it will
keep me quite so he can watch the great escape.
All I need now is 2 million lines of code ;-(
Rita

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:474F77C5-4727-4A1D-82E2-22AD2953228E@news.elevatesoft.com...
> David
>
>
> I'll go with Rita - nice looking website (videos are a bit quiet though),
> nice looking product. I'm always fascinated, and jealous, about the niches
> people manage to find.
>
> Good luck.
>
> Roy Lambert
>

Roy,

<< You do realise that when I get 1.07 and function results are evaluated
correctly I have to try and duplicate this for non text indexed columns
don't you! >>

That kind of defeats the whole purpose of text indexes.

However, in the edbstring.pas unit there is this function:

function MatchString(const Value: TEDBString;
                    const Pattern: TEDBString;
                    const EscapeCharacter: TEDBChar;
                    CaseSensitive: Boolean): Boolean;

it performs all of the hard work with regard to the pattern matching.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Rita,

I used the ExGrid control, but it took a lot of hard graft to make it work right.

Since its an ActiveX grid we dropped it in favour of a grid we wrote ourselves.

The database we use is SQL Express, I want to use elevatedb for offline storage.

Thanks for the nice comments.

Regards,

David

Tim



>That kind of defeats the whole purpose of text indexes.

Errm, so doing a lookup on a non-indexed field (string, integer, date or anything) defeats the whole purpose of indexes?
WRONG!! It translates to "on these columns I want to find the info fast and I think I'll want to find it a lot, on these columns though I won't be looking very often, but may want to occasionally so I don't mind if its slower BUT I do want the capability if and when I want it but I'm not prepared to use disk or cpu to make it fast"

Its a bit like some people can't live without indexing their entire computer so they can find a text file quickly whilst others will happily wait for the few minutes (in my case say 15 mins before I get fed up) to find something.

It looks like the enemy (aka MicroSoft) have taken your viewpoint with Vista unless you have indexing enabled all it will do (at least according to itself) is check filenames not content.

>However, in the edbstring.pas unit there is this function:

Brill - I'll have a look when I get 1.07 - thanks

Roy Lambert