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, hr_posn_numb, hr_posn_desc FROM v_SchoolPosition WHERE (hr_wdep_code =7036) AND 1 = 0
go
IF @@TRANCOUNT > 0 ROLLBACK TRAN
go
set implicit_transactions off
go
SELECT hr_wdep_code, hr_posn_numb, hr_posn_desc FROM v_SchoolPosition WHERE hr_wdep_code =7036
go
set implicit_transactions on SET NO_BROWSETABLE ON
go
SELECT hr_wdep_code, hr_posn_numb, hr_posn_desc FROM v_SchoolPosition WHERE 1 = 0
go
IF @@TRANCOUNT > 0 ROLLBACK TRAN
go
set implicit_transactions off
go
SELECT hr_wdep_code, hr_posn_numb, hr_posn_desc FROM v_SchoolPosition
go
I'm not sure what I did wrong nor how to fix it :(, does anybody have any idea?
Your help is much appreciated
Regards
Peter