Re: ModifySQLQuery

Hilary Stoupa — Wed, 31 Oct 2012 14:59:58 GMT

Hi - have you put the Qdabra Rules error node on your form so you can see if there is an error? Are you just running the command, and not re-executing the data connection afterward? From the user guide:

This command will allow you to add a WHERE clause to an existing SQL data connection. It will execute the SQL query after adding the WHERE clause.

ModifySQLQuery

SoftEx — Wed, 31 Oct 2012 02:14:28 GMT

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

Newbie Questions

Re: ModifySQLQuery

ModifySQLQuery