OleDbCommandBuilder - Data type mismatch in criteria expression

15 Nov 2007 9:00 AM

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

15 Nov 2007 4:51 PM

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)
-----------------------------------------------------------------------------------------------------------------------

Show quote

"john" <u***@example.net> wrote in message
news:7VT_i.170134$%k.311002@twister2.libero.it...
> 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