Why "Syntax error in UPDATE statement" error? 
Author Message
 Why "Syntax error in UPDATE statement" error?
The sql query I have is:

UPDATE Kund SET Namn='Nisse', Banknr='12345',
Kontonr='54321', Adress='Nissev', Postnr=12345,
Ort='Nisseborg', Vxl=True, Best=False, Inl=False
WHERE Kundnr=12345

And in the Access database
Namn, Banknr, Kontonr, Adress, Ort is of type Text
Postnr, Kundnr is of type Number
Vxl, Best, Inl is of type Yes/No

When I'm running this query i get "Syntax error in UPDATE
statement" error. What is wrong?

Mon, 12 Sep 2005 03:14:13 GMT
 [ 1 post ] 

 Relevant Pages 

1. "Syntax Error in expression" strange error

2. Local View Returning "Syntax Error"

3. Insert Into "Syntax error"

4. ADO "syntax error in FROM clause"

5. Forms 9i "Invalid Syntax Error".

6. linked servers "Error Incorrect Syntax near.."

7. MySQL - "NOT IN" syntax error

8. "Syntax error in my FROM clause"

9. "Syntax Error" in VFP5

10. Write # Statement "Null Error"

11. "Missing comma" error with SQL statement

12. "Statement too long" error

Powered by phpBB® Forum Software