Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
asterix literal in filter |
Tue, Aug 28 2007 6:18 PM | Permanent Link |
"Steve Barker" | Hi,
I'm having trouble with this filter since upgrading from dbisam3 to 4: OrderNo='110253' AND (SUBSTRING( INo FROM 1 FOR 1 )<>'*') The customer uses '*' as first character in Ino field to denote non-stock order items. Is this character now an alternative for wildcard? Is there a way to specify it as a literal? (I tried '\*') regards, Steve |
Tue, Aug 28 2007 7:39 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Steve,
<< I'm having trouble with this filter since upgrading from dbisam3 to 4: OrderNo='110253' AND (SUBSTRING( INo FROM 1 FOR 1 )<>'*') The customer uses '*' as first character in Ino field to denote non-stock order items. Is this character now an alternative for wildcard? Is there a way to specify it as a literal? (I tried '\*') >> Set the FilterOptions to include the foNoPartialCompare flag and that will fix the issue. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Aug 30 2007 10:01 AM | Permanent Link |
Chris Erdal | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in
news:7EB1BAC3-825A-4082-BD26-4E10082615F0@news.elevatesoft.com: > Is this character now an alternative for wildcard? Is there a way to > specify it as a literal? (I tried '\*') >> > > Set the FilterOptions to include the foNoPartialCompare flag and that > will fix the issue. > Tim, could you clarify the question above, as I thought SQL didn't allow * as a wildcard? Setting foNoPartialCompare would presumably not allow finding literal stars in partial comparisons using % or _? -- Chris (XP-Pro + Delphi 7 Architect + DBISAM 4.25 build 4 + EDB 1.04 build 3) |
Thu, Aug 30 2007 5:21 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Chris,
<< could you clarify the question above, as I thought SQL didn't allow * as a wildcard? >> It doesn't - only filters do as a compatibility layer with the BDE. << Setting foNoPartialCompare would presumably not allow finding literal stars in partial comparisons using % or _? >> foNoPartialCompare only affects asterisks in = <> comparisons and does not affect LIKE comparisons, even in filters. -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Sep 1 2007 6:10 AM | Permanent Link |
Chris Erdal | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in
news:0B4F77CD-D144-4C53-BAD6-3EAEA3F916F8@news.elevatesoft.com: > Chris, > ><< could you clarify the question above, as I thought SQL didn't allow >* as > a wildcard? >> > > It doesn't - only filters do as a compatibility layer with the BDE. > ><< Setting foNoPartialCompare would presumably not allow finding >literal > stars in partial comparisons using % or _? >> > > foNoPartialCompare only affects asterisks in = <> comparisons and does > not affect LIKE comparisons, even in filters. > Thanks. I'd sort of missed that we were talking about filters, but it's all quite clear now. -- Chris (XP-Pro + Delphi 7 Architect + DBISAM 4.25 build 4 + EDB 1.04 build 3) |
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |