Input parameters not working on Update in Database operator

[Legacy User]

I've used the Query Database operator with input parameters successfully before am currently having trouble getting the Update in Database operator to work.  I am trying to update the change order table for Service desk in the mdb.  In this update statement I simply want to change the type for a given change order.

 

update chg

set chgtype = '300'

where chg_ref_num = ?

 

The update statement works if I run it in SQL giving the chg_ref_num

 

update chg

set chgtype = '300'

where chg_ref_num = '462960'

 

But if I use an input parameter of Process.test where I set the variable to 462960, I receive an error 'the value is not set for the parameter number 1'.

 

The JDBCInputParamArray shows it bringing in the variable correctly.

 

Any ideas?

[Anon Anon]

I would open an issue for this.  It works when I do either of the following:

update chg set chgtype='300' where chg_ref_num='123456'

update chg set description='test' where chg_ref_num=?   (and supplying an input value)

 

But not when doing what you do:

update chg set chgtype='300' where chg_ref_num=?   (and supplying an input value)

[Anon Anon]

Why not use the Service Desk Connector instead of directly updating the mdb?

[Daniel Mattes]

i'm getting the same issue with the 4.2 version, and i didn't had this situation with the 3.1 one, but i'm not trying to update the database, just doing a select. i've already opened a ticket about it, but they instructed me to look foward in the communities.ca about it.

[Anon Anon]

The Service Desk Connector also has the ability to do a select.  Is that not an option?