ADO query

[mogura]

I am using ADOs in the initial coding of a VB datatbase application. I have created an ADO Command object named cndMyCommand and associated it with an ADO Connection object named cnnMyConnection. I want to issue the following UPDATE statement against the database:

UPDATE Employees SET Salary = Salary * 1.10

Is this the correct command to do this?

Set cndMyCommand.CommandText = “UPDATE Employees SET Salary = Salary * 1.10”
cndMyCommand.Execute

If it isn’t can you tell me what I’m doing wrong?

Thanks.

 

[SonOfEmidec1100]

Dont use SET when assigning the commandtext, and I would make the command type specific, if you havent elsewhere.

cndMyCommand.CommandType = adCmdText
cndMyCommand.CommandText = “UPDATE Employees SET Salary = Salary * 1.10”