Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 4 of 4 total |
IN with nothing between the brackets |
Wed, Feb 6 2013 4:43 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Is there a possibility that IN could return FALSE when the condition between the brackets is empty rather then generating an error? I have a number of statements like Contacts.Filter := '_ID IN (' + Restrict.FieldByName(_ContactList).AsString + ')'; I'm wrapping them in a test to see if there's anything there. Failing that could we have a more explicit error message please? Maybe Empty IN test rather than ElevateDB Error #700 An error was found in the statement at line 6 and column 9 (Expected expression but instead found )) Roy Lambert |
Wed, Feb 6 2013 3:58 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Is there a possibility that IN could return FALSE when the condition between the brackets is empty rather then generating an error? >> Sure, I can throw that in there. Tim Young Elevate Software www.elevatesoft.com |
Thu, Feb 7 2013 7:21 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< Is there a possibility that IN could return FALSE when the condition >between the brackets is empty rather then generating an error? >> > >Sure, I can throw that in there. Brill, as long as it isn't going to break ooodles of code. Roy Lambert |
Thu, Feb 14 2013 10:52 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Brill, as long as it isn't going to break ooodles of code. >> Nah, simple fix. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |