problems with data of decimal type!

Videle · Aug 9th, 2004, 08:08 AM

I have read a lot of stuff, but haven't found anything needful! You are my last hope

So the problem is:
my database is created by using Access 2000. Some fields have data of decimal type.
so when i run my program and try to set new records and display them into datagrid I get the error "Data type mismatch in criteria expression".
I have noticed, that my program don't understand, what a comma is. Simple it is missed then I try to save new records.
example:
I set: 565,236
after saving: 565236

Everything is OK, when I set Single type instead Decimal type, but I need Decimal type...

If somebody has any seggetions, please, let me know!

szlamany · Aug 9th, 2004, 08:49 AM

COMMA in the THOUSANDS position is a formatting character - it should not be stored in the DB or sent to the DB for storage. It is not a number with a "COMMA" in the thousands position.

BTW - not sure what you meant by SINGLE type - but you should not convert DECIMAL DB types to SINGLE (floating point) - try currency datatype, maybe...

Videle · Aug 10th, 2004, 05:13 AM

I think now I understand my problem.
In my country the decimal separator is a comma (,) and in most country the decimal separator is a point (.).
So when I changed (Contral Panel/Regional and Language settings) Standarts and Formats to English, then the problem disappeared...

Aug 9th, 2004, 08:08 AM	#1
Videle New Member Join Date: Aug 04 Location: Lithuania Posts: 2	problems with data of decimal type! I have read a lot of stuff, but haven't found anything needful! You are my last hope So the problem is: my database is created by using Access 2000. Some fields have data of decimal type. so when i run my program and try to set new records and display them into datagrid I get the error "Data type mismatch in criteria expression". I have noticed, that my program don't understand, what a comma is. Simple it is missed then I try to save new records. example: I set: 565,236 after saving: 565236 Everything is OK, when I set Single type instead Decimal type, but I need Decimal type... If somebody has any seggetions, please, let me know!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Aug 9th, 2004, 08:49 AM	#2
szlamany MS SQL Powerposter Join Date: Mar 04 Location: CT Posts: 12,366	COMMA in the THOUSANDS position is a formatting character - it should not be stored in the DB or sent to the DB for storage. It is not a number with a "COMMA" in the thousands position. BTW - not sure what you meant by SINGLE type - but you should not convert DECIMAL DB types to SINGLE (floating point) - try currency datatype, maybe...

Aug 10th, 2004, 05:13 AM	#3
Videle New Member Join Date: Aug 04 Location: Lithuania Posts: 2	I think now I understand my problem. In my country the decimal separator is a comma (,) and in most country the decimal separator is a point (.). So when I changed (Contral Panel/Regional and Language settings) Standarts and Formats to English, then the problem disappeared...

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)