topic Re: JTXSteps.ExecuteSQL :Invalid arguments name in ArcGIS Workflow Manager Questions

JTXSteps.ExecuteSQL :Invalid arguments name

RajeshMane — Sat, 28 Jul 2012 07:20:19 GMT

I am using JTXSteps.ExecuteSQL to perform update activity by using tokens

I have written following in arguments :

/database:[SYS:CUR_DATABASE] /sql:Update JTX_JOBS_AOI set JOB_ID = [JOB:ID] where JOB_ID = [JOB:PARENT_JOB]

When I validate the argument it saty "Argument Names Invalid"
What I observed is , could be because of spaces in SQL command. How to overcome this ?

Re: JTXSteps.ExecuteSQL :Invalid arguments name

NishiMishra — Tue, 31 Jul 2012 14:56:41 GMT

Rajesh,

Since there are spaces in the SQL command you need to put your sql command with quotes like /sql:"Update JTX_JOBS_AOI set JOB_ID = [JOB:ID] where JOB_ID = [JOB:PARENT_JOB]".

Your argument would then be written as:
/database:[SYS:CUR_DATABASE] /sql:"Update JTX_JOBS_AOI set JOB_ID = [JOB:ID] where JOB_ID = [JOB:PARENT_JOB]"