Devart Forums

Posted: **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.

Posted: **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.

Devart Forums

TVirtualQuery "LIKE" Issue

TVirtualQuery "LIKE" Issue

Re: TVirtualQuery "LIKE" Issue