Error Question

[darude]

Hello,
I am creating a query from two tables that belong to an Oracle database. I get the error message "Scaling of decimal value resulted in data truncation" when running the query. I tried using the round function, it gives the same message. Thanks for any help you can provide.

 

[DotNetGnat]

may be you need to cast it as a float or double...

-DNG

 

[darude]

Thanks for your response. That doesn't seem to work either. Changing the data type works when just running the query, but it fails when running a make-table. We are trying to pull data into our system from another source. If you have other suggestions let me know. Thanks.

 

[DotNetGnat]

there should be way to set the scale settings...

-DNG

 

[darude]

I did think about that but since I have no control over the scale settings in the Oracle design or changing those settings in any way I don't see that as an option in this case. Am I wrong?

Another thing I tried is to create an access table structure with everything (including the scale settings) set correctly and then using an append query to bring the data in. That didn't work either I got the same error message. That leads me to believe that the problem is with the link through access to the oracle data source.

Any other suggestions? I'm open to any information I can get based on the fact that I'm on a deadline and getting desperate!!!

 

[DotNetGnat]

can i look at your query?? atleast a part of it that results in this error

-DNG