Tim

Can you clarify these two points please

- EXISTS support

- Text indexing allows for multiple wildcards in word searches

Roy Lambert

Roy,

<<  - EXISTS support >>

It's the function, not the DDL clause.

<< - Text indexing allows for multiple wildcards in word searches >>

Yeah, I forgot to mention that I added that a while ago.   I was waiting
until 2.0 to document it, but accidentally mentioned it in that email.  It
means that you can use something like this and still have it work:

MyColumn CONTAINS '*Test*'

It will return all rows where the word Test is anywhere *within* any other
word, or is the word itself.   It's like LIKE with leading and trailing
wildcards.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< - EXISTS support >>
>
>It's the function, not the DDL clause.

I suppose I should have looked it up but I had a sudden surge of hope

><< - Text indexing allows for multiple wildcards in word searches >>
>
>Yeah, I forgot to mention that I added that a while ago. I was waiting
>until 2.0 to document it, but accidentally mentioned it in that email. It
>means that you can use something like this and still have it work:
>
>MyColumn CONTAINS '*Test*'
>
>It will return all rows where the word Test is anywhere *within* any other
>word, or is the word itself. It's like LIKE with leading and trailing
>wildcards.

It might mean a bit more work in the conversion but since that's a slog anyway is it worth switching * to % so its the same as the sql stuff?

Another question just occured to me - is there a list anywhere of what doesn't work in filters?

Roy Lambert

Roy,

<< Another question just occured to me - is there a list anywhere of what
doesn't work in filters? >>

Yes, here:

http://www.elevatesoft.com/scripts/manual.dll?action=mantopic&id=edb1&product=d&version=7&category=4&topic=35

"The only differences...."

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


And just to double check - UDF's are allowed? If so would this be a way of overcoming the joins not allowed thing?

Roy Lambert

Roy,

<< And just to double check - UDF's are allowed? If so would this be a way
of overcoming the joins not allowed thing? >>

I knew you were going to ask that. Yes, UDFs are allowed now.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Rahhhh

Roy Lambert