Solved

Problem Writing to SQL

Posted on 2006-11-17
4
122 Views
Last Modified: 2010-04-30
I am having difficulties writing to a SQL database.  The field I am having problems with is a decimal format.  With a length of 5 characters, a precision of 9 and a scale of 6.  I'm not exactly sure what all of those mean (I didn't create the database), but the error message that I am getting is as follows:  

"Multiple-step OLE DB operation generated errors.  Check each OLE DB status value, if available.  No work was done."

If I change the data type to varchar in the database, the program runs through fine.

The # it is trying to enter to the database is: 3801.5784

Thanks in advance for the help.
0
Comment
Question by:jayh99
4 Comments
 
LVL 1

Author Comment

by:jayh99
ID: 17965125
Nevermind, I found that the format I was receiving in wasn't what the database was looking for.  The number needed to be divided by 100.  Thanks.
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 50 total points
ID: 17965130
>a precision of 9 and a scale of 6.
means you have maximum 3 digits before the comma and 6 after. hence 3801 is too big.

change the precision to at least 10 (better 18), and keep the scale of 6.
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question