Invalid precision value
Hi,
I'm trying to execute a function in a loop using studio but I'm having an error; "ODBC driver for sql server Invalid precision value"
Any help please?
Example :
for i=1:1:2{
...
set pars(1) = -1
set pars(2) ="A"
set pars(3)= "A"
set pars(4)="B"
set pars(5)="C"
set pars(6)="D"
set pars(7)="E"
set pars(8)="F"
set pars = 8
set status = ..Adapter.ExecuteUpdateParmArray(.tRe, expression1,.pars)
}
It's working fine for the first time, but when it tries to execute for the second time I'm getting the error : "ODBC driver for sql server Invalid precision value"
You need to kill the pars parameter array and recreate it each time you use it. This is mentioned in the documentation:
https://docs.intersystems.com/csp/docbook/DocBook.UI.Page.cls?KEY=ESQL_parameter_overview