Question
· May 30, 2017

ExecuteUpdateParmArray() problems

Hi everyone,

i have a problem with the "ExecuteUpdateParmArray()" methode from the "EnsLib.SQL.OutboundAdapter" adaptater when i try to update a sql server 2008 table with JDBC connection.

..Adapter.ExecuteUpdateParmArray(.nRows,sqlUpdate,.param)

return to me the following error:

- "ERROR #5023: Remote Gateway Error: JDBC Gateway execUpdate(0) error -1: no value specified for parameter 1."

the sqlUpdate is like "update table SET column1 = ?,column2 = ?,column3 = ? where id = 1"

i built my param like this :

s param(1) = 'x'
s param(2) = 'y'
s param(3) = 'z'
s param = 3

i have no proleme for using

..Adapter.ExecuteQueryParmArray(.tResult,sqlSelect,.param)

with the sqlSelect like "select ?,?,? from table where id = 1 " and i build "param" exactly the same way.

what's wrong with the ExecuteUpdateParmArray methode ? is the methode need a different "param" ?

Thx for your time.

Discussion (3)1
Log in or sign up to continue