NEWBIE: easy syntax question with UPDATE statement 
Author Message
 NEWBIE: easy syntax question with UPDATE statement

Hi:
being a newbie, i simply cannot find the error in the following UPDATE
statement that is thrown by vb.net and sql query analyzer:

Server: Nachr.-Nr. 170, Schweregrad 15, Status 31, Zeile 5
Line 2: Wrong Syntax near '('. (this is translated from german :))

according to the above error msg the error has to be somewhere around
the first opening bracket of the second line, but i just cant find it
!!!!!!!!!!!!!!

UPDATE OrderDetails
(OrderID, ProductID, Quantity)




PLEASEEEEEEEEE HELP!!!!
TIA -- Calderone



Wed, 19 Jan 2005 18:01:47 GMT
 NEWBIE: easy syntax question with UPDATE statement

UPDATE OrderDetails




Regards
    Kresimir Radosevic


Quote:
> Hi:
> being a newbie, i simply cannot find the error in the following UPDATE
> statement that is thrown by vb.net and sql query analyzer:

> Server: Nachr.-Nr. 170, Schweregrad 15, Status 31, Zeile 5
> Line 2: Wrong Syntax near '('. (this is translated from german :))

> according to the above error msg the error has to be somewhere around
> the first opening bracket of the second line, but i just cant find it
> !!!!!!!!!!!!!!

> UPDATE OrderDetails
> (OrderID, ProductID, Quantity)




> PLEASEEEEEEEEE HELP!!!!
> TIA -- Calderone



Wed, 19 Jan 2005 18:31:13 GMT
 NEWBIE: easy syntax question with UPDATE statement

try (not tested but heading in the right direction)






HTH
Alan


Quote:
>Hi:
>being a newbie, i simply cannot find the error in the following UPDATE
>statement that is thrown by vb.net and sql query analyzer:

>Server: Nachr.-Nr. 170, Schweregrad 15, Status 31, Zeile 5
>Line 2: Wrong Syntax near '('. (this is translated from german :))

>according to the above error msg the error has to be somewhere around
>the first opening bracket of the second line, but i just cant find it
>!!!!!!!!!!!!!!

>UPDATE OrderDetails
>(OrderID, ProductID, Quantity)




>PLEASEEEEEEEEE HELP!!!!
>TIA -- Calderone



Wed, 19 Jan 2005 18:38:08 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Newbie - Easy (I think) SQL Syntax Question, 3 table join

2. Newbie question: Syntax problem with CASE statement

3. Probably easy syntax question

4. Easy SQL Syntax Question

5. Easy SQL Syntax Question

6. Easy question on trigger syntax....

7. (0x80040E14) Syntax error in UPDATE statement.

8. Syntax error in UPDATE statement while using a Memo field

9. Help with SQL update statement syntax

10. SQL Update Statement Syntax Help

11. Need help with Syntax on Update or Insert SQL Statement

12. UPDATE statement syntax


 
Powered by phpBB® Forum Software