Question
· Aug 2, 2018

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"

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