I'm using the ADO Command object to update records. Using the below example, everything updates fine.

objCommand.CommandText = "UPDATE subs SET department = '" & _
                         strDepart1 & "' WHERE department = '" & _
                         strDepart & "'"

However, if I try to update multiples such as:

objCommand.CommandText = "UPDATE subs SET department = '" & _
                         strDepart1 & "' AND empl = '" & _
                         employee1 & "' WHERE department = '" & _
                         strDepart & "'"

It places empty data in the DB. Can anyone tell me why this is? Am I doing something wrong in my update statement?

Once again, any help would be greatly appreciated.

Chris

Hi there,

For an UPDATE statement, you shouldn't use AND, except for in the WHERE clause.

Here's the general UPDATE syntax:

UPDATE MyTable SET
  MyFirstTextColumn = 'MyValue',
  MySecondTextColumn = 'MyOtherValue',
  MyFirstNumberColumn = 3
WHERE bla bla.

I don't understand why this isn't throwing an error, though....

Cheers,

Imar



---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks Imar!

No error message was received at all. Just that it deleted data from the first field that I know was there, and did not any other fields specified.

Thanks again!