odbc update fails

		Wrox Programmer Forums > PHP/MySQL > MySQL
odbc update fails

MySQL General discussion about the MySQL database.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

February 22nd, 2005, 08:23 PM

iecanfly

Registered User

Join Date: Jan 2005

Posts: 2

Thanks: 0

Thanked 0 Times in 0 Posts

odbc update fails

I am using odbcadapter to connect to
the MySql database and the update command
faises an exception if there's no change in
the datarow.

ie)
DataRow1 -> ID : 1 and Value : 'ABC'
If i change the Value field of DataRow1 to 'CBA'
it works fine but if I change it to 'ABC'(no change),
the update fails. Any idea?

Cheers
David

love never fails

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Fails To Update	sirmilt	BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5	12	May 8th, 2008 11:16 AM
Update Fails - Database is Read-Only	pete robinson	Classic ASP Basics	3	December 19th, 2007 02:40 PM
update/delete fails when row contains null values	davej	ASP.NET 2.0 Basics	2	December 6th, 2006 03:47 PM
Problems in ASP.NET 2 when I update my ODBC databa	Armando Barbarin Rionda	ASP.NET 1.0 and 1.1 Professional	1	July 1st, 2005 01:20 AM
Problems in ASP.NET 2 when I update my ODBC databa	Armando Barbarin Rionda	ASP.NET 1.0 and 1.1 Professional	0	June 30th, 2005 05:07 PM