Getting syntax error for update query.

Question

0.00/5 (No votes)

See more:

SQL

UPDATE Parts SET Parts.DispositionIDX =Disposition.DispositionIDX 
 FROM Parts INNER JOIN Disposition ON Parts.DispositionIDX = Disposition.Disposition
 WHERE PartIDX =7

What I have tried:

What am i missing here

Posted 14-Dec-17 9:57am

Member 13017730

Updated 15-Dec-17 3:01am

PIEBALDconsult

v2

Add a Solution

Comments

CHill60 14-Dec-17 17:12pm

What is the actual error?
And this is not VB.Net!

Suvendu Shekhar Giri 14-Dec-17 21:11pm

Doesn't look to be a syntax error.
Please share the actual error message.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 13017730 · Answer 1 · 2017-12-15T03:01:00

I do have columns DispositionIDX and Disposition in my Disposition Table and DispositionIDX in my Parts table.

I am trying to update the Parts table when user changes the disposition.
In the parts table, dispositionIDX is number(integer) but in my Datagrid i am displaying the Disposition(String) from disposition table using combobox ex - Hold, Process...etc it stores its IDX in parts table in db.
When the user changes the disposition in the datagrid it should change its Disposition IDX in the table, thats where i am trying to execute this query first in MSAccess.

Syntax Error says : Syntax error(Missing Operator) in query expression 'Disposition.DispositionIDX from Parts Inner Join Disposition ON Parts.DispositionIDX = Disposition.DispositionIDX

CHill60 · Answer 2 · 2017-12-14T23:02:00

The only syntax error I can see you being able to get is one of the following:

Msg 208, Level 16, State 1, Line 1
Invalid object name 'Parts'.

Msg 208, Level 16, State 1, Line 1
Invalid object name 'Disposition'.

Msg 4104, Level 16, State 1, Line 2
The multi-part identifier "Parts.Disposition" could not be bound.

Msg 207, Level 16, State 1, Line 2
Invalid column name 'Disposition'.

Msg 207, Level 16, State 1, Line 3
Invalid column name 'PartIDX'.

- 208 Errors - you have misspelled the name of the table you want to use
- 207 Errors - you have misspelled the name(s) of (a) column you want to use
- 4104 Error - you have misspelled the name of the column on the join (or mixed up which column is in which table)

It does look very much as if you have a column DispositionIDX on your Disposition table but are trying to join using (a possibly non-existent) column Disposition

If this doesn't help then reply with the text of the actual error message

Getting syntax error for update query.

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0