Page 1 of 1

In new SDAC 6.7 TMSQuery.foCaseInsensitive doesn't work

Posted: Wed 15 May 2013 04:43
by Lithium™
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.

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

Posted: Wed 15 May 2013 07:52
by Lithium™
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.

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

Posted: Wed 15 May 2013 11:34
by AndreyZ
Hello,

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