Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Currency Data type in Access DB
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 10 December 2004 :  12:29:07  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
I've never dealt with this type of field before... not sure if I want to.

What would the syntax be for inserting data into this field via SQL Statements?

-Stim

sr_erick
Senior Member

USA
1318 Posts

Posted - 10 December 2004 :  13:05:18  Show Profile  Visit sr_erick's Homepage  Send sr_erick a Yahoo! Message
Basically inserting integers works, or decimals. 10 or 10.95. The database should take care of the rest, at least I know MSSQL does.




Erick
Snowmobile Fanatics

Go to Top of Page

dayve
Forum Moderator

USA
5820 Posts

Posted - 10 December 2004 :  14:19:09  Show Profile  Visit dayve's Homepage
keep the number as an integer and format it to currency in your code.

Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 10 December 2004 :  14:42:23  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
easy enuf, thx guys

-Stim
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 13 December 2004 :  04:30:53  Show Profile  Send pdrg a Yahoo! Message
Nothing special about it, in fact it can be used as a small float - holds 4 (or is it 5) dp's, which is the most regularly used precision for currency calculations (eg if VAT is 17.33% multiplied by £0.17, the precision required for storing the result is 5 [or is it 4...?] dp)

Not sure about Dayve's suggestion - for this to work you would need to store the cents value - but you would lose precision in the above example.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07