SQL UPDATE Command

Question

Question. I'm trying to use SQL to update a listview in C#. Using the Query Builder I can do a select, update, insert and delete. Ive got my select but I'm trying to get my update to work with no luck.( I want to use the update button on the listview to update the record) I need some insight as I think I'm writing it wrong. Thanks

 UPDATE       SF1411
 SET  ( ItemNumber, QuoteNumber, Item, Descp, Route, Unit, QTYOH, EXTQTY, CSTCD, 
      PCOST, SCOST, ACOST, TCOST, ICOST, Date, BIZCODE, DeleteItem)   
  =  SELECT [ItemNumber], [QuoteNumber], [Item], [Descp], [Route], [Unit], [QTYOH], 
     [EXTQTY], [CSTCD], [PCOST], [SCOST], [ACSOT], [TCOST], [ICOST], [Date], [BIZCODE],   
    [DeleteItem] 
    FROM [SF1411] WHERE ([QuoteNumber] = @QuoteNumber)

can use post a small C# sample code and the error that occurs? — user432219
– user432219, Commented Dec 29, 2010 at 13:14

Danish Khan · Accepted Answer · 2010-12-29 13:39:08Z

2

Im sorry if I understand you wrong, but shouldn't an update statement look like this..

UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value

answered Dec 29, 2010 at 13:39

Danish Khan

1,8915 gold badges22 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nakul Chaudhary · Accepted Answer · 2010-12-29 13:43:51Z

0

If I am correct your update command is wrong.

you need to tell value of each column rather than just fire a select command.

answered Dec 29, 2010 at 13:43

Nakul Chaudhary

26.2k15 gold badges47 silver badges49 bronze badges

Comments

Nick is tired · Accepted Answer · 2022-04-01 20:29:20Z

0

Just set individual values like below:

UPDATE SF1411
SET ItemNumber = SELECT [ItemNumber] FROM [SF1411] WHERE ([QuoteNumber] = @QuoteNumber);

Mostly this is used to update a specific value or if using select in set then it used to select from different table like:

Update table set column= "value" where condition;

or:

Update table set column = select column from tbl where condition;

edited Apr 1, 2022 at 20:29

Nick is tired

7,17721 gold badges44 silver badges55 bronze badges

answered Mar 31, 2022 at 5:47

Vanshika

1

Collectives™ on Stack Overflow

SQL UPDATE Command

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related