“十进制值的缩放导致数据被截断".通过ODBC [英] "Scaling of decimal value resulted in data truncation" via ODBC

问题描述

仅在MS Access中查看ODBC表时，我收到错误的十进制值缩放导致数据截断"错误.我知道正在返回错误的字段，Access能够在查询该字段时识别出该字段，但是我无法查看结果(#Error记录)，并且错误不断消失.

I'm receiving an error of "Scaling of decimal value resulted in data truncation" when simply trying to view an ODBC table in MS Access. I know the field that is returning the error, and Access is able to recognize the field when querying off of it, but I'm not able to view the results (#Error records) and the error keeps kicking back.

我没有运气尝试过CDbl(). Nz()甚至不允许查询运行.

I've tried CDbl() with no luck. A Nz() doesn't even allow the query to run.

源数据库是Oracle，通过Microsoft Windows x64的数据库客户端11g第2版连接.该字段由数据字典定义为长度为22的Number.设计视图显示字段Decimal，精度为13，但标度为2.

The source database is Oracle, connected via Database Client 11g Release 2 for Microsoft Windows x64. The field is defined by the data dictionary as Number with a length of 22. Design view shows the fields a Decimal with precision of 13, but a scale of 2.

我猜是2的小数位数引起了此错误.我通过MS Access链接表.无论如何，我是否可以通过访问Access和ODBC来解决此问题，还是需要在Oracle中解决?

I'm guessing the scale of 2 is causing this error. I'm linking the table via MS Access. Is there anyway for me to resolve this with access to Access and the ODBC, or does this need to be resolved in Oracle?

推荐答案

Oracle服务器最近将其比例从2更改为4，以实现更高的精度.在服务器上进行更改时，链接的MS Access表不会更新.必须删除表并重新链接以刷新秤.

The Oracle server recently changed its scale from 2 to 4 to allow the greater precision. Linked MS Access tables do not update when the change is made on the server. The table must be removed and relinked for the scale to refresh.

这篇关于“十进制值的缩放导致数据被截断".通过ODBC的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！