OleDbCommandBuilder - Data type mismatch in criteria expression

  • Thread starter Thread starter john
  • Start date Start date
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
 
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)
 
Back
Top