Thread: Command Builder
View Single Post
  #1 (permalink)  
Old April 12th, 2005, 08:39 AM
BSkelding BSkelding is offline
Authorized User
 
Join Date: Mar 2004
Location: Maumee, OH, USA.
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default Command Builder

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?