-
Error in UPDATE statement
Hello,
I'm kinda new to Aspdb. How can I trace this error when I can't see the Update sql?
I perform adds and updates on other tables in the same Access db. What would I look for in this
table or code that produces this error?
Error # = 80040E14
Description = [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
NativeError = -3503
Thanks, ST
-
Error in UPDATE statement (reply)
Good question Steve,
Simply turn on the dbDebug flag as shown:
MyDb.dbDebug = true
Now you'll see the update statement and should be able to spot your error.
Thanks for the question,
John
P.S. Full details are in the docs - just search for debug
------------
Steve Talley at 4/27/99 9:32:57 PM
Hello,
I'm kinda new to Aspdb. How can I trace this error when I can't see the Update sql?
I perform adds and updates on other tables in the same Access db. What would I look for in this
table or code that produces this error?
Error # = 80040E14
Description = [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
NativeError = -3503
Thanks, ST
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|