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.
set chgtype = '300'
where chg_ref_num = ?
The update statement works if I run it in SQL giving the chg_ref_num
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.
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)
Why not use the Service Desk Connector instead of directly updating the mdb?
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.
The Service Desk Connector also has the ability to do a select. Is that not an option?