943,582 Members | Top Members by Rank

Ad:
Nov 6th, 2008
0

can't write a decimal to a recordset in VB 5.0

Expand Post »
When I enter a decimal into a field by the time it gets written to a recordset it has been changed to zero if the value is less than one and it is rounded up if the value is greater than one.
Any suggestions?
Reputation Points: 10
Solved Threads: 0
Light Poster
stan yost is offline Offline
29 posts
since Aug 2006
Nov 6th, 2008
1

Re: can't write a decimal to a recordset in VB 5.0

please check the datatype of that field in your database and check their properties if how many decimal have set.
Reputation Points: 11
Solved Threads: 49
Posting Whiz
jireh is offline Offline
316 posts
since Jul 2007
Nov 7th, 2008
0

Re: can't write a decimal to a recordset in VB 5.0

Thanks. I feel like a dummy. The data type in Access was Number but the decimal places was set to Auto. Once I changed auto to 2 it worked.
Reputation Points: 10
Solved Threads: 0
Light Poster
stan yost is offline Offline
29 posts
since Aug 2006

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: converting this code from ms access to mysql
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: print issue problem





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC