OleDbCommandBuilder - Data type mismatch in criteria expression

J

john

Hi, i'm using an OleDbCommandBuilder to update data from a dataset to a
access database.
It work fine, but if i use a table with a decimal column data type, i
get this error, when performing the update

Data type mismatch in criteria expression

i've understood that the error is due to the comma or dot in the decimal
representation in the sql statements, but they are created automatically
by the command builder.
Any idea on how to fix that?
Thanks
 
W

William Vaughn

You mean besides not using the Command(Don'tUse)Builder? Most pros have
abandoned using the CB some time ago.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
 

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

OleDbCommandBuilder - Data type mismatch in criteria expression 2
I'm going slightly mad - OleDbCommandBuilder 1
Using ADO.Net on machines with comma for decimal point 2
Using CommandBuilder to update an Access table from a DataGridView 2
Command builder question 1
OleDbCommandBuilder insert query will not work? dataset to Access 4
Newbie: OleDbCommandBuilder won't work 1
HELP!! - Data type mismatch in criteria expression 1

Top