TVirtualQuery "LIKE" Issue

Discussion of open issues, suggestions and bugs regarding Virtual Data Access Components for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
polisoft
Posts: 1
Joined: Fri 03 May 2019 05:58

TVirtualQuery "LIKE" Issue

Post by polisoft » Fri 03 May 2019 06:13

Hi ,
I'm already a licensed user of Universal Data Access Components (VCL) product. (Latest version 7.4.12)
I'm using the one which TVirtualQuery object located in UniDAC.
Problem I'm having is with "LIKE" Queries;


please check the examples below , (city_name="MOSCOW")
these works well (returns MOSCOW)

Code: Select all

SELECT * FROM cities WHERE city_name LIKE "MOSCO%"
or

Code: Select all

SELECT * FROM cities WHERE city_name LIKE "%SCOW"

although , this does not work (doesn't return record set);

Code: Select all

SELECT * FROM cities WHERE city_name LIKE "%SCO%"
or

Code: Select all

SELECT * FROM cities WHERE city_name LIKE "%MOSCOW%"
it's an urgent issue to solve for me any helps appreciated.

MaximG
Devart Team
Posts: 1506
Joined: Mon 06 Jul 2015 11:34

Re: TVirtualQuery "LIKE" Issue

Post by MaximG » Wed 08 May 2019 12:51

Thank you for the information. We have fixed the error, the changes will be released in the next build of our product. As a temporary solution, we are sending you the download link to the UniDAC nightly build that comes with the fix.

Post Reply