kevind
Posts: 251
|
Posted: 05/03/2013, 5:43 PM |
|
Is there a way to capture a form's SQL statement in the Before Update event section and store it to a Session variable for debugging.
I'm getting a JET error for which I can find no cause and it would be helpful to see the SQL.
thanks in advance
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
netsys
Posts: 39
|
Posted: 05/06/2013, 8:08 PM |
|
After your SQL update or add statement, add these lines:
errormessage = CCProcessError(Connection)
response.Write errormessage
response.Write SQL
response.end
Be sure and change the Connection name if you've changed your Connection name to be something besides Connection. This will show you the SQL and not process the data.
|
|
|
|