Error in UPDATE statement

[Steve Talley]

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

[John]

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