UPDATE SQL and ADO 1

[PaidtheUmpire]

How do you do it?

I want to update a varaible in my table from the value in the system to value B.


is it something like this?

UPDATE Field_Name TO Variable
FROM Table_Name
WHERE Name = 'Bill';

 

[Zathras]

UPDATE Table_Name
SET Field_Name = Variable
WHERE Name = 'Bill'

or, if Field_Name is defined as CHAR or VARCHAR,

UPDATE Table_Name
SET Field_Name = 'Variable'
WHERE Name = 'Bill'

There are several SQL fora here. Check them out.

 

[PaidtheUmpire]

Thanks for that but i can't get it to work...

The program tells me that it says the following

ADOQuery1: CommandText doesn't return a result set.

Any ideas on fixing this?

 

[Zathras]

It sounds like you may be trying to use the Open method with that SQL statement. When doing UPDATEs (or INSERTs) the method to use is ExecSQL. "Open" is used for SELECT statements.

If that doesn't help, you should post more of your code so we can see exactly what it is that you are trying to do.