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

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Thread Solved

Join Date: Aug 2006
Posts: 29
Reputation: stan yost is an unknown quantity at this point 
Solved Threads: 0
stan yost stan yost is offline Offline
Light Poster

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

 
0
  #1
Nov 6th, 2008
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?
Reply With Quote Quick reply to this message  
Join Date: Jul 2007
Posts: 300
Reputation: jireh is an unknown quantity at this point 
Solved Threads: 43
jireh's Avatar
jireh jireh is offline Offline
Posting Whiz

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

 
1
  #2
Nov 6th, 2008
please check the datatype of that field in your database and check their properties if how many decimal have set.
Reply With Quote Quick reply to this message  
Join Date: Aug 2006
Posts: 29
Reputation: stan yost is an unknown quantity at this point 
Solved Threads: 0
stan yost stan yost is offline Offline
Light Poster

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

 
0
  #3
Nov 7th, 2008
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.
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:



Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



Tag cloud for Visual Basic 4 / 5 / 6
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC