In new SDAC 6.7 TMSQuery.foCaseInsensitive doesn't work

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Lithium™
Posts: 42
Joined: Wed 23 Jun 2010 06:42

In new SDAC 6.7 TMSQuery.foCaseInsensitive doesn't work

Post by Lithium™ » Wed 15 May 2013 04:43

Hello.
I've just installed new version of SDAC (SDAC 6.7.13 for RAD Studio XE2, Delphi XE2 Update 4 Hotfix 1) and found out that TMSQuery.FilterOptions.foCaseInsensitive stopped work. Filter became case sensitive.
Therefore I had to rollback this upgrade.
Could you please check it? I'm waiting for reply. Thanks.

Lithium™
Posts: 42
Joined: Wed 23 Jun 2010 06:42

Re: In new SDAC 6.7 TMSQuery.foCaseInsensitive doesn't work

Post by Lithium™ » Wed 15 May 2013 07:52

I have localized a little the problem. Here is a small example:

My dataset has field dstItemsContragent: TWideStringField.
Dataset contains many rows and one of them is 'Envirocoustics (Инвайракустикс), Greece'.

I try to filter my dataset

Code: Select all

dstItems.Filter := 'Contragent = ''*Envir*'''; -- works properly
dstItems.Filter := 'Contragent = ''*envir*'''; -- works properly
dstItems.Filter := 'Contragent = ''*Инвайр*'''; -- works properly
dstItems.Filter := 'Contragent = ''*инвайр*'''; -- doesn't work properly
Previos version of SDAC 6.1.5 for RAD Studio XE (which I'm currently using) works properly in all cases.

AndreyZ

Re: In new SDAC 6.7 TMSQuery.foCaseInsensitive doesn't work

Post by AndreyZ » Wed 15 May 2013 11:34

Hello,

Thank you for the information. We have fixed this problem. This fix will be included in the next SDAC build.

Post Reply