请大家来看看这是什么错误

[chenay]

ASP做的程序，后台数据库用的SYBASE,在运行ASP程序时，出现“Truncation error occurred”错误，这是由于SYBASE的设置问题呢还是其他原因？请高手指点，谢谢！

[chenay]

upself!

[superkun]

错误号码??

[chenay]

to 天天刷牙：
请问你查看的什么文档，是关于SYBASE错误处理的吗?哪里有这样的文档，你手头有吗？
若是方便的话，给个地址或我发一份吧！[e-mail],谢谢！
现在程序已经不出问题了，什么措施也没实行就好了，怪怪的。
请天天刷牙给个回复，马上结贴！

[chenay]

原来的错误是这样的：
Error#=-2147467259
Error description=[INTERSOLV][OCBC SQL Server driver][SQL Server]Truncation error occurred.
前面的错误描述是自己写的容错处理。程序以前运行良好，不知何故出现此错误，有知道的请告知，万分感谢！

[n_tianya]

没见过这个错，帮你查了一下文档，如下：
Error 3624
Severity 10

Message text:
Truncation error occurred.

Explanation :
The precision of a datatype denotes the maximum number of digits allowed in columns of that datatype. For the exact numeric types dec, decimal and numeric,the allowed range of data depends on the column’s precision as well as its scale,that is, the maximum number of digits that are allowed to the right of thedecimal point.

Error 3624 occurs when an operation inserts data into a target column or
variable but the precision or scale of the target are too small for the data. The
operation fails and the command is aborted.

Action:
Examine the data involved in the arithmetic operation to ensure that the target column or variable is sized appropriately.

Additional information:
The set arithabort and set arithignore options specify behavior following loss of precision or (for exact numeric types) loss of scale.