|Subject||Re: [firebird-support] Problems with update command|
> > 2) When my customer tried running it, he got the following error:Is there any way to test for this in my query? i.e. something like...
> > ISC ERROR CODE: 335544321
> > arithmetic exception, numeric overflow, or string truncation
> > What could cause that error?
>That at least in one case the resulting field ( proddesc || other values
>that you concatenate here) is longer than the proddesc is declared.
>PRODDESC = VARCHAR(50)
>Length of entry Length of appended value
>30 10 ok
>40 10 ok
>40 11 not ok, since Result is 51
>1 40 ok
>1 50 not ok
...and length(proddesc) < 30
That is, other than a SP or UDF?