Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 7 of 7 total |
The upgrade email |
Thu, Feb 21 2008 4:26 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Can you clarify these two points please - EXISTS support - Text indexing allows for multiple wildcards in word searches Roy Lambert |
Thu, Feb 21 2008 1:19 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Feb 21 2008 1:59 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Thu, Feb 21 2008 2:26 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Feb 22 2008 2:36 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Fri, Feb 22 2008 6:48 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Sat, Feb 23 2008 4:04 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Rahhhh Roy Lambert |
This web page was last updated on Wednesday, June 12, 2024 at 01:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |