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%"
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%"
Code: Select all
SELECT * FROM cities WHERE city_name LIKE "%MOSCOW%"