Welcome, Guest. Register Now!
   
Mark Forums Read Mark Forums Read Mark Forums Read


Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-30-2008, 06:07 AM
Junior Member
 
Join Date: Oct 2007
Posts: 5
iTrader: (0)
Imagineer is on a distinguished road
Default Problem with numeric field

In the database, I've got a numeric field which has to store up to 9 numbers of which 2 are decimals. Now I tried everything in the notation and number of decimals etc but whatever I do, it keeps going wrong. If I fill in 22,33 (the 33 is the decimals) I get as a result either 2233 of 22. Can someone give me some insight with what I need to fill in as field details for this to work?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 01-31-2008, 06:41 AM
Member
 
Join Date: Oct 2007
Posts: 41
iTrader: (0)
TonyES is on a distinguished road
Default

You will need to use single or double as field size, or perhaps currency datatype. I suspect you are using integer or long integer.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 01-31-2008, 10:56 PM
Junior Member
 
Join Date: Oct 2007
Posts: 5
iTrader: (0)
Imagineer is on a distinguished road
Default

Thanks for advice
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -6. The time now is 03:02 AM.