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

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

"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)

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

"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)