UPDATE sql

[weijian]

If I saystrSQL = "UPDATE Users SET Course = " & intNewID & " WHERE Course = " & intOldIDbut it does not execute correctly. It does not give me any error whatsoever but it doesn't work. What's wrong?

[davidrobin]

This may seem a silly question but the Course field is not a key field is it.

When you say it does not work does nothing at all happen or does something unexpected happen.

[monte96]

It would be helpful if you post the error text as well..

[anizmohammed]

Hey did you executed the stated in the ADO connection



aniz

[monte96]

Sorry, I read your post wrong..

Post the code you are using to execute the query.

[davidrobin]

Let me put it this way.

When you do execute the command what exactly does happen and can you post some extra code to demonstrate how and when the code is being executed.