access problem

  • Thread starter Thread starter dzemo
  • Start date Start date
D

dzemo

I use access file for database. in one table I have column with number
(decimal 18,2) type. When I modify data manually it work file. But when I
write data using program made in VB.NET (oledbCommand) thought parameter I
have problem with decimals. 20,00 work fine but 2,20 writes like 22. Why?
Thx
 
U¿ytkownik "dzemo said:
I use access file for database. in one table I have column with number
(decimal 18,2) type. When I modify data manually it work file. But when I
write data using program made in VB.NET (oledbCommand) thought parameter I
have problem with decimals. 20,00 work fine but 2,20 writes like 22. Why?
Click to expand...

Maybe you should write 2.20?
Regards,
Grzegorz
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

decimal separator, regional settings 9
Access stripping decimal places in query 1
Trouble writing to Access db 2
OleDbCommandBuilder - Data type mismatch in criteria expression 1
Storing decimals to Pervasive SQL database 3
problem with accessing decimal values in MS SQL 2000 4
Problem accessing fox pro database on a network 5
Using CommandBuilder to update an Access table from a DataGridView 2

Back
Top