I'm trying to use the command builder to generate my Update command for a MySQL table. I pass in the Select statment and the update query is created correctly. However, when it updates the database a new record is created instead of updating the original record. Below is a sample Select query passed in to the command builder.

SELECT * FROM IndAccums WHERE SS = '111222333' AND Year = '2005' AND
PatientID = '888999XX'

Any idea why it would create a new record instead of actually performing the update?

Are you using a command object or a sql data adapter?

I believe you need to use the data adapter in order for it to generate the other SQL commands automatically.

No, I am using the data adapter to generate the commands. It actually generates the commmand correctly, as far as I can tell, but the update does not go as expected.

Can you post your code that calls the UPDATE?