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 expression1 = "exec [po_dm].[dbo].[UP_ED_TE_IT] @P__TE_IT_ID = ?, @P__TE_ID = ?, @P__TE_RA_ID = ? ,@P__TE_VAL = ?, @P__LOW_REF = ?, @P__HIGH_REF = ?, @P__LOW_CRI= ?, @P__HIGH_CRI=? "
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"
Comments
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
Important:
If you execute multiple queries that use the parameter array, kill and recreate the parameter array before each query.