Syntax error in UPDATE statement 
Author Message
 Syntax error in UPDATE statement
There must be a difference between der ODBC Driver for SQL Server and
Microsoft Access. The code I use is running perfect using the ODBC
Driver for SQL Server but stopping with error when using the MS Access
driver.

Im executing an positioned Update command like:

UPDATE TestType SET float = ? WHERE CURRENT OF SQL_CUR00d680a8

And the Error is:

[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE
statement.)
State(42000)

what the hell is wrong????



Mon, 31 May 2004 16:34:29 GMT
 
 [ 1 post ] 

 Relevant Pages 

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

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

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

4. Syntax error in UPDATE statement

5. HE: Syntax Error in UPDATE statement

6. Syntax Error in Update Statement

7. Why "Syntax error in UPDATE statement" error?

8. -2147217900 Error: Syntax error in INSERT INTO statement

9. NEWBIE: easy syntax question with UPDATE statement

10. Help with SQL update statement syntax

11. SQL Update Statement Syntax Help

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


 
Powered by phpBB® Forum Software