Invalid precision value

Caché, Ensemble

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"

  • 0
  • 0
  • 219
  • 0
  • 1

Answers