UPDATE sql

**weijian** · May 21st, 2001, 04:51 AM

If I say

Code:

strSQL = "UPDATE Users SET Course = " & intNewID & " WHERE Course = " & intOldID

but it does not execute correctly. It does not give me any error whatsoever but it doesn't work. What's wrong?

**davidrobin** · May 21st, 2001, 07:33 AM

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** · May 21st, 2001, 10:33 AM

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

**anizmohammed** · May 22nd, 2001, 01:27 AM

Hey did you executed the stated in the ADO connection

aniz

**monte96** · May 22nd, 2001, 02:03 AM

Sorry, I read your post wrong..

Post the code you are using to execute the query.

**davidrobin** · May 22nd, 2001, 02:55 AM

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.

Thread: UPDATE sql

Thread Tools

Display

UPDATE sql

did you execute?

Posting Permissions