I'm submitting a standard query with 'like' operator in the where clause. I'm setting Request live to True, but the program is not sending a Live Result set back.
the select statement is
select area10."FILENAME", area10."SPC_NO" from area10 where area10."SPC_NO" LIKE '%232%'
where area10 is the table name and 232 is to be found in one record of the SPC_NO field.
If I substitute "where area10."SPC_NO" = '12321' this returns a live result set, but with the like operator it does not. The Delphi documentation state like operators should return live sets, is the documentation incorrect or am I doing something wrong.