Debug not working anymore

HDumas · Post by **HDumas** » Wed 17 Feb 2010 14:35

Hello,
Using Delphi 7 and ODAC 5.50.
I was always able to use the debug by setting Debug = True and including the OdacVcl in the uses section of my unit.
Maybe it is a coincidence... but since I have reinstalled Delphi and the ODAC components on my new PC, it does not work.
I am able to make it work in the demos, but in my own application, it does not work.
I have tried to use the debug with the TOraQuery or TSmartQuery... with or without cachedupdate...
And now it is causing me a headache because I have a exception error on the POST (class N_18 with message 'Unknown error 1") and I cannot see the debug window that shows me the values being passed to my UpdateSQL of my TOraquery...

HELP!!! I have been working on the problem for 2 days now....

Challenger · Post by **Challenger** » Thu 18 Feb 2010 13:36

The problem with the Debug property is very strange. We need more information about you project, and now we could not reproduce it . As to the error on Post you can get the problem statement using dbMonitor.

HDumas · Post by **HDumas** » Thu 18 Feb 2010 13:57

I have found part of the problem...
My DEBUG is still not working, but I found out why it is giving me this error on the Post...
In the Update SQL, I have a BEGIN... END; with two update statements.. one is short (it updates 2 columns of a table), but the other one I generate with the SQL generator of the TSmartQuery because the table has 255 columns. Trying to look for the column that was giving me problems, I found that it was not the values in the columns, but the number of columns being updated... I deleted two columns from the update statement, and now the Post works like a charm... so I think the the ODAC component has a maximum of lines in the SQL.
As for the DEBUG... what would you like to know about my project?