Hi
I have the following command on a change fields value:
concat("ModifySqlQuery /dsname=SchoolPositions /where= WHERE hr_wdep_code =", .)
The problem is that it still return ALL the data in the table and IGNORE the where clause. On closer inspection under SQL Profiler I found the following:
SELECT hr_wdep_code, ...